Conditional

IIF

DuckDB

Alias untuk IF function. SQL Server-compatible syntax untuk kondisional sederhana.

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

Syntax

SQL

IIF(condition, true_value, false_value)

Parameter

conditionBOOLEANwajib

Kondisi yang akan dievaluasi

true_valueANYwajib

Nilai jika kondisi TRUE

false_valueANYwajib

Nilai jika kondisi FALSE

Contoh Penggunaan

Basic IIF

SQL

1 SELECT
2   employee_name,
3   IIF(salary > 50000, 'High', 'Low') AS salary_band
4 FROM employees;

Klasifikasi gaji dengan IIF.

IIF dengan NULL Handling

SQL

1 SELECT
2   product_name,
3   IIF(stock IS NULL OR stock = 0, 'Out of Stock', 'In Stock') AS availability
4 FROM products;

Handle NULL dan zero stock.

Multiple IIF

SQL

1 SELECT
2   customer_name,
3   IIF(vip_status, 'VIP', 'Regular') AS tier,
4   IIF(total_orders > 10, 'Loyal', 'New') AS loyalty
5 FROM customers;

Multiple independent IIF.

IIF dalam Agregasi

SQL

1 SELECT
2   department,
3   SUM(IIF(status = 'active', 1, 0)) AS active_count,
4   SUM(IIF(status = 'inactive', 1, 0)) AS inactive_count
5 FROM employees
6 GROUP BY department;

Conditional counting dengan IIF.

Fungsi Equivalen di Database Lain

CASE

PostgreSQL

MySQL

IFF

Snowflake

BigQuery

Fungsi Terkait

CASEIFDECODE

Kembali ke DuckDB Functions

1	SELECT
2	employee_name,
3	IIF(salary > 50000, 'High', 'Low') AS salary_band
4	FROM employees;

1	SELECT
2	product_name,
3	IIF(stock IS NULL OR stock = 0, 'Out of Stock', 'In Stock') AS availability
4	FROM products;

1	SELECT
2	customer_name,
3	IIF(vip_status, 'VIP', 'Regular') AS tier,
4	IIF(total_orders > 10, 'Loyal', 'New') AS loyalty
5	FROM customers;

1	SELECT
2	department,
3	SUM(IIF(status = 'active', 1, 0)) AS active_count,
4	SUM(IIF(status = 'inactive', 1, 0)) AS inactive_count
5	FROM employees
6	GROUP BY department;