Conditional

COALESCE

BigQuery

Mengembalikan nilai non-NULL pertama dari daftar expressions.

Tipe hasil: Type of expressionsDiperbarui: 7 Jan 2026

Syntax

SQL

COALESCE(expression1, expression2, ...)

Parameter

expression1, expression2, ...anywajib

Nilai-nilai untuk dicek

Contoh Penggunaan

First Non-NULL

SQL

1 SELECT
2   COALESCE(NULL, NULL, 'default') as result,
3   COALESCE(mobile_phone, home_phone, office_phone, 'No phone') as phone
4 FROM `project.dataset.contacts`;

Mengambil nilai non-NULL pertama.

Hasil

result	phone
default	08123...

Fungsi Terkait

NULLIFNVLIFNULL

Kembali ke BigQuery Functions

1	SELECT
2	COALESCE(NULL, NULL, 'default') as result,
3	COALESCE(mobile_phone, home_phone, office_phone, 'No phone') as phone
4	FROM `project.dataset.contacts`;