Conditional

ZEROIFNULL

Snowflake

Mengembalikan 0 jika expr adalah NULL, jika tidak mengembalikan expr.

Tipe hasil: Same as inputDiperbarui: 6 Jan 2026

Syntax

SQL

ZEROIFNULL(expr)

exprnumericwajib

Expression numerik

SQL

1 SELECT
2   SUM(ZEROIFNULL(quantity)) as total_quantity
3 FROM inventory;

Menghitung total dengan NULL = 0.

IFNULL

MySQL

1	SELECT
2	SUM(ZEROIFNULL(quantity)) as total_quantity
3	FROM inventory;