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
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
No comments:
Post a Comment