Conditional

NVL2

Snowflake

Mengembalikan expr2 jika expr1 bukan NULL, jika tidak mengembalikan expr3.

Tipe hasil: Same as expr2/expr3 typesDiperbarui: 6 Jan 2026

Syntax

SQL

NVL2(expr1, expr2, expr3)

expr1anywajib

Expression yang dicek NULL

expr2anywajib

Nilai jika expr1 NOT NULL

expr3anywajib

Nilai jika expr1 NULL

SQL

1 SELECT
2   employee_name,
3   NVL2(manager_id, 'Has Manager', 'Top Level') as position
4 FROM employees;

Cek apakah punya manager.

SQL

1 SELECT
2   product_name,
3   NVL2(discount, price * (1 - discount), price) as final_price
4 FROM products;

Apply discount jika ada.

NVL2

DuckDB

1	SELECT
2	employee_name,
3	NVL2(manager_id, 'Has Manager', 'Top Level') as position
4	FROM employees;

1	SELECT
2	product_name,
3	NVL2(discount, price * (1 - discount), price) as final_price
4	FROM products;