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 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.