Conditional

IFNULL

BigQuery

Mengembalikan expression jika tidak NULL, otherwise mengembalikan null_replacement.

Tipe hasil: Type of expressionsDiperbarui: 7 Jan 2026

Syntax

SQL

IFNULL(expression, null_replacement)

expressionanywajib

Nilai yang dicek

null_replacementanywajib

Nilai pengganti jika NULL

SQL

1 SELECT
2   name,
3   IFNULL(nickname, name) as display_name
4 FROM `project.dataset.users`;

Gunakan name jika nickname NULL.

Hasil

name	display_name
John	Johnny
Mary	Mary

COALESCE

PostgreSQL

IFNULL

MySQL

NVL

Snowflake

COALESCE

DuckDB

1	SELECT
2	name,
3	IFNULL(nickname, name) as display_name
4	FROM `project.dataset.users`;