NULLIF

Prevent division by zero with NULLIF.

NULLIF(a, b) returns NULL if a equals b, otherwise a. It is used to avoid division by zero.

SELECT total / NULLIF(count, 0) AS ort FROM orders;

If count is 0 the result is NULL; no error.

total / NULLIF(count, 0) AS ort is selected from orders.

NULLIF — details

NULLIF(x, 0) prevents a divide-by-zero error. Combine with COALESCE to replace NULL with another value.

Compute total / count from orders; avoid error when count is 0.

Show example solution

SELECT total / NULLIF(count, 0) AS ort
FROM orders

Zero guard

SELECT total / ____(count, 0) FROM orders;

Show answer

SELECT total / NULLIF(count, 0) FROM orders;