Conditional

IFNULL

DuckDB

Mengembalikan default_value jika value adalah NULL, otherwise mengembalikan value. Versi 2-argumen dari COALESCE.

Tipe hasil: Tipe dari value atau default_valueDiperbarui: 6 Jan 2026

Syntax

SQL

IFNULL(value, default_value)

Parameter

valueANYwajib

Nilai yang akan dicek

default_valueANYwajib

Nilai default jika value NULL

Contoh Penggunaan

Default Value Sederhana

SQL

1 SELECT
2   product_name,
3   IFNULL(discount, 0) AS discount
4 FROM products;

Default 0 untuk discount NULL.

Default String

SQL

1 SELECT
2   customer_name,
3   IFNULL(phone, 'Not provided') AS phone
4 FROM customers;

Placeholder text untuk NULL.

Dalam Agregasi

SQL

1 SELECT
2   category,
3   SUM(IFNULL(quantity, 0)) AS total_qty,
4   AVG(IFNULL(price, 0)) AS avg_price
5 FROM products
6 GROUP BY category;

Handle NULL dalam agregasi.

IFNULL vs COALESCE

SQL

1 -- Keduanya equivalent untuk 2 argumen
2 SELECT
3   IFNULL(value, 0) AS using_ifnull,
4   COALESCE(value, 0) AS using_coalesce
5 FROM data;
6  
7 -- COALESCE untuk lebih dari 2 fallbacks
8 SELECT COALESCE(a, b, c, 0) AS result FROM data;

Perbandingan IFNULL dan COALESCE.

Fungsi Equivalen di Database Lain

COALESCE

PostgreSQL

IFNULL

MySQL

NVL

Snowflake

IFNULL

BigQuery

Fungsi Terkait

COALESCENULLIFNVLNVL2

Kembali ke DuckDB Functions

1	SELECT
2	product_name,
3	IFNULL(discount, 0) AS discount
4	FROM products;

1	SELECT
2	customer_name,
3	IFNULL(phone, 'Not provided') AS phone
4	FROM customers;

1	SELECT
2	category,
3	SUM(IFNULL(quantity, 0)) AS total_qty,
4	AVG(IFNULL(price, 0)) AS avg_price
5	FROM products
6	GROUP BY category;

1	-- Keduanya equivalent untuk 2 argumen
2	SELECT
3	IFNULL(value, 0) AS using_ifnull,
4	COALESCE(value, 0) AS using_coalesce
5	FROM data;
6
7	-- COALESCE untuk lebih dari 2 fallbacks
8	SELECT COALESCE(a, b, c, 0) AS result FROM data;