Conditional

IF

DuckDB

Mengembalikan true_value jika kondisi TRUE, otherwise false_value. Shorthand untuk CASE dengan satu kondisi.

Tipe hasil: Tipe dari true_value atau false_valueDiperbarui: 6 Jan 2026

Syntax

SQL

IF(condition, true_value, false_value)

conditionBOOLEANwajib

Kondisi yang akan dievaluasi

true_valueANYwajib

Nilai jika kondisi TRUE

false_valueANYwajib

Nilai jika kondisi FALSE atau NULL

SQL

1 SELECT
2   product_name,
3   price,
4   IF(price > 100, 'Premium', 'Standard') AS tier
5 FROM products;

Klasifikasi sederhana berdasarkan harga.

SQL

1 SELECT
2   user_name,
3   IF(is_active, 'Active', 'Inactive') AS status
4 FROM users;

Mengkonversi boolean ke label.

SQL

1 SELECT
2   order_id,
3   amount,
4   IF(is_member, amount * 0.9, amount) AS final_amount
5 FROM orders;

Diskon untuk member.

SQL

1 SELECT
2   score,
3   IF(score >= 90, 'A',
4     IF(score >= 80, 'B',
5       IF(score >= 70, 'C', 'D')
6     )
7   ) AS grade
8 FROM students;

Nested IF (tapi CASE lebih readable).

CASE

PostgreSQL

MySQL

IFF

Snowflake

BigQuery

1	SELECT
2	product_name,
3	price,
4	IF(price > 100, 'Premium', 'Standard') AS tier
5	FROM products;

1	SELECT
2	user_name,
3	IF(is_active, 'Active', 'Inactive') AS status
4	FROM users;

1	SELECT
2	order_id,
3	amount,
4	IF(is_member, amount * 0.9, amount) AS final_amount
5	FROM orders;