NULLIF function

Question

NULLIF function

Accepted Answer

NULLIF(a, b) returns NULL when a equals b, otherwise it returns a. Here NULLIF(value, 0) converts zeros to NULL. This is useful before division - NULLIF(denominator, 0) prevents division-by-zero errors because dividing by NULL produces NULL rather than an error.