What does the NULLIF(expr1, expr2) function return when expr1 equals expr2?

Question

SQL Fundamentals — Medium

What does the NULLIF(expr1, expr2) function return when expr1 equals expr2?

Accepted Answer

The NULLIF(expr1, expr2) function returns NULL when expr1 equals expr2. This function is used to handle cases where two expressions are equal and you want to return NULL instead.