Conditional

NULLIF

BigQuery

Mengembalikan NULL jika kedua expression sama, otherwise mengembalikan expression1.

Tipe hasil: Type of expression1 or NULLDiperbarui: 7 Jan 2026

Syntax

SQL

NULLIF(expression1, expression2)

expression1anywajib

Nilai yang dikembalikan jika tidak sama

expression2anywajib

Nilai untuk dibandingkan

SQL

1 SELECT
2   numerator,
3   denominator,
4   numerator / NULLIF(denominator, 0) as safe_div
5 FROM `project.dataset.data`;

Division aman dengan NULLIF.

Hasil

numerator	denominator	safe_div
10	2	5
10	0	NULL

1	SELECT
2	numerator,
3	denominator,
4	numerator / NULLIF(denominator, 0) as safe_div
5	FROM `project.dataset.data`;