Conditional

COALESCE

Snowflake

Mengembalikan nilai non-NULL pertama dari daftar expression.

Tipe hasil: Common type of inputsDiperbarui: 6 Jan 2026

Syntax

SQL

COALESCE(expr1, expr2, ...)

expr1, expr2, ...anywajib

Expression yang dievaluasi berurutan

SQL

1 SELECT COALESCE(mobile_phone, home_phone, work_phone, 'No phone') as contact_phone
2 FROM contacts;

Mengambil nomor telepon pertama yang ada.

SQL

1 SELECT
2   product_name,
3   COALESCE(sale_price, regular_price, 0) as price
4 FROM products;

Cascade harga: sale > regular > 0.

1	SELECT COALESCE(mobile_phone, home_phone, work_phone, 'No phone') as contact_phone
2	FROM contacts;

1	SELECT
2	product_name,
3	COALESCE(sale_price, regular_price, 0) as price
4	FROM products;