NULLIF
Returns NULL if the two values are equal, otherwise returns the first, as in NULLIF(value1, value2).
SELECT NULLIF(value1, value2) FROM t;
When to use
Not asked in the past papers or problem sets; it is a Read 01 keyword. A common use is turning a placeholder value into NULL.
See Read 01.