Conditional

NVL

BigQuery

Alias untuk IFNULL. Mengembalikan null_replacement jika expression NULL.

Tipe hasil: Type of expressionsDiperbarui: 7 Jan 2026

Syntax

SQL

NVL(expression, null_replacement)

expressionanywajib

Nilai yang dicek

null_replacementanywajib

Nilai pengganti jika NULL

SQL

1 SELECT NVL(NULL, 'default') as result;

Sama dengan IFNULL.

Hasil

result
default

COALESCE

PostgreSQL

IFNULL

MySQL

NVL

Snowflake

COALESCE

DuckDB