Conditional

IFNULL

Snowflake

Mengembalikan expr1 jika bukan NULL, jika tidak mengembalikan expr2.

Tipe hasil: Same as input typesDiperbarui: 6 Jan 2026

Syntax

SQL

IFNULL(expr1, expr2)

expr1anywajib

Expression yang dicek NULL

expr2anywajib

Nilai pengganti jika expr1 NULL

SQL

1 SELECT IFNULL(discount, 0) as actual_discount
2 FROM products;

Mengganti NULL dengan 0.

SQL

1 SELECT
2   customer_name,
3   IFNULL(phone, 'No phone') as phone_display
4 FROM customers;

Menampilkan default text untuk NULL.

1	SELECT IFNULL(discount, 0) as actual_discount
2	FROM products;

1	SELECT
2	customer_name,
3	IFNULL(phone, 'No phone') as phone_display
4	FROM customers;