Conditional

NULLIFZERO

Snowflake

Mengembalikan NULL jika expr sama dengan 0, jika tidak mengembalikan expr.

Tipe hasil: Same as inputDiperbarui: 6 Jan 2026

Syntax

SQL

NULLIFZERO(expr)

exprnumericwajib

Expression numerik

SQL

1 SELECT
2   total_amount / NULLIFZERO(quantity) as unit_price
3 FROM orders;

Menghindari division by zero.

NULLIF

DuckDB

1	SELECT
2	total_amount / NULLIFZERO(quantity) as unit_price
3	FROM orders;