IFNULL
Compares two expressions. Returns <expression1> if it’s non-NULL, otherwise returns <expression2>.
Syntax
IFNULL(<expression1>, <expression2>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<expression1>, <expression2> | Expressions that evaluate to any data type that Firebolt supports. | Any |
Return Types
Same as input type
Remarks
Use ZEROIFNULL(<expression>) as a synonym shorthand for IFNULL(<expression1>, 0).
Example
The following truth table demonstrates values that IFNULL returns based on the values of two columns: level and player_id:
SELECT level, player_id, IFNULL(level,player_id), IFNULL(player_id,level)
FROM players;
| level | player_id | IFNULL(level,player_id) | IFNULL(player_id,level) | |:———-|:—————|:————————|:————————| | 0 | 32 | 0 | 32 | | 1 | null | 30 | 30 | | null | 33 | 33 | 33 | | null | null | null | null | +———–+—————-+————————-+————————-+