Skip to Main Content

Case statement in where clasue

Example

WHERE  ( 1 = CASE
        WHEN <column_a> != <column_b> AND <column_c> = 1 
           THEN
                 1
        WHEN <column_a> =  NVL( <column_b>, -1 )  
            THEN
                 1
        ELSE
                 0
        END 
       )