NULLIF ()

NULLIF function returns NULL, if both passed expression are same.
If both expressions are not same then this function returns first expression as an result.

SELECT NULLIF(1,1) ------> NULL
SELECT NULLIF (1,2) ------> 1

facebook page