Multiple choice technology programming languages

NULLIF function returns _____ if the arguments are not equal

  1. NULL

  2. First argument

  3. Second argument

  4. None of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The SQL NULLIF function compares two expressions. If they are equal, it returns NULL. If they are not equal, it returns the value of the first argument. Returning the second argument or NULL when they differ is incorrect according to SQL standards.