Conditional

NULLIF

Snowflake

Mengembalikan NULL jika expr1 sama dengan expr2, jika tidak mengembalikan expr1.

Tipe hasil: Same as expr1 typeDiperbarui: 6 Jan 2026

Syntax

SQL

NULLIF(expr1, expr2)

expr1anywajib

Expression yang akan dikembalikan

expr2anywajib

Nilai pembanding

SQL

1 SELECT
2   revenue / NULLIF(units, 0) as price_per_unit
3 FROM sales;

Menghindari error divide by zero.

SQL

1 SELECT NULLIF(email, '') as email_or_null
2 FROM users;

Mengubah empty string menjadi NULL.

1	SELECT
2	revenue / NULLIF(units, 0) as price_per_unit
3	FROM sales;