NULLIF() Function:-
NULIF() is a Function which compares 2 values. If the two values are equal then it will return null else it will return the 1st value.
Ex :
NULLIF(12, 12) would return NULL
NULLIF(12, 13) would return 12
NULIF() is a Function which compares 2 values. If the two values are equal then it will return null else it will return the 1st value.
Ex :
NULLIF(12, 12) would return NULL
NULLIF(12, 13) would return 12
No comments:
Post a Comment