SQL · System and metadata

nullifzero()

Returns NULL when the value is zero. Useful for safe division.

sqlRunnable example sql course

Syntax

nullifzero(value)

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.