IFNULL

Syntax

IFNULL( check_value, alt_value )

Description

Returns check_value if it's not NULL. Otherwise returns alt_value.

Argument types:

  • check_valueAny
  • alt_valueAny

Return type: Same type as (check_value, alt_value)

Note

Arguments (check_value, alt_value) must be of the same type.

Example

[sales] IFNULL([sales], -100.0)
432.40 432.40
77.00 77.00
12000.00 12000.00
NULL -100.00
34.25 34.25
128.00 128.00
0.00 0.00
NULL -100.00

Data source support

ClickHouse 21.8, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, YDB.

Previous
Next