Conditional

IFF

Snowflake

Mengembalikan satu dari dua nilai berdasarkan kondisi (shorthand untuk simple CASE).

Tipe hasil: Same as input valuesDiperbarui: 6 Jan 2026

Syntax

SQL

IFF(condition, true_value, false_value)

conditionBOOLEANwajib

Kondisi untuk dievaluasi

true_valueanywajib

Nilai jika kondisi true

false_valueanywajib

Nilai jika kondisi false atau NULL

SQL

1 SELECT
2   score,
3   IFF(score >= 60, 'Pass', 'Fail') as result
4 FROM exams;

Pass/fail berdasarkan skor.

SQL

1 SELECT
2   order_total,
3   IFF(order_total > 100, order_total * 0.9, order_total) as final_total
4 FROM orders;

Diskon 10% untuk order > 100.

MySQL

BigQuery

DuckDB

CASE

PostgreSQL

1	SELECT
2	order_total,
3	IFF(order_total > 100, order_total * 0.9, order_total) as final_total
4	FROM orders;