Conditional

NVL

DuckDB

Mengembalikan nilai pertama jika tidak NULL, jika NULL mengembalikan nilai kedua. Alias Oracle-style dari IFNULL/COALESCE.

Tipe hasil: Sama dengan tipe inputDiperbarui: 6 Jan 2026

Syntax

SQL

NVL(expression, replacement)

expressionanywajib

Nilai yang akan dicek NULL-nya

replacementanywajib

Nilai pengganti jika expression NULL

SQL

1 SELECT
2   customer_name,
3   NVL(phone, 'No Phone') as phone,
4   NVL(email, 'No Email') as email
5 FROM customers;

Mengganti NULL dengan teks default.

Hasil

SQL

1 SELECT
2   product_name,
3   price,
4   discount_percent,
5   price * (1 - NVL(discount_percent, 0) / 100) as final_price
6 FROM products;

Menggunakan 0 sebagai default jika discount NULL.

Hasil

product_name	price	discount_percent	final_price
Laptop	1500000	10	1350000
Phone	800000	NULL	800000
Tablet	500000	5	475000

SQL

1 SELECT
2   department,
3   SUM(NVL(bonus, 0)) as total_bonus,
4   AVG(NVL(bonus, 0)) as avg_bonus
5 FROM employees
6 GROUP BY department;

Memperlakukan NULL bonus sebagai 0 dalam agregasi.

Hasil

COALESCE

PostgreSQL

IFNULL

MySQL

NVL

Snowflake

IFNULL

BigQuery

1	SELECT
2	product_name,
3	price,
4	discount_percent,
5	price * (1 - NVL(discount_percent, 0) / 100) as final_price
6	FROM products;