Conditional

IF

BigQuery

Mengembalikan satu nilai jika kondisi TRUE, nilai lain jika FALSE.

Tipe hasil: Type of result expressionsDiperbarui: 7 Jan 2026

Syntax

SQL

IF(condition, true_result, false_result)

conditionBOOLwajib

Kondisi untuk dievaluasi

true_resultanywajib

Nilai jika TRUE

false_resultanywajib

Nilai jika FALSE atau NULL

SQL

1 SELECT
2   name,
3   IF(age >= 18, 'Adult', 'Minor') as category
4 FROM `project.dataset.users`;

Kategorisasi berdasarkan umur.

Hasil

name	category
John	Adult
Mary	Minor

CASE

PostgreSQL

MySQL

IFF

Snowflake

DuckDB

1	SELECT
2	name,
3	IF(age >= 18, 'Adult', 'Minor') as category
4	FROM `project.dataset.users`;