SQL · Reading data

nullif

Returns null when the two values are equal. Useful for avoiding division by zero.

sqlRunnable example sql course

Syntax

nullif(a, b)

Example

Open in the lab

SELECT 10 / NULLIF(0, 0) AS safe;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.