NULLIF
Learn how to use the NULLIF condition function in PlaidCloud Lakehouse. Returns NULL if two expressions are equal, otherwise returns the first expression.
Returns NULL if two expressions are equal, otherwise returns the first expression.
Analyze Syntax
func.nullif(get_column(table, 'value'), 0)
Analyze Examples
func.nullif(get_column(table, 'divisor'), 0)
SQL Syntax
NULLIF(<value>, 0)
SQL Examples
SELECT 100 / NULLIF(divisor, 0) AS safe_division FROM calculations;
┌───────────────┐
│ safe_division │
├───────────────┤
│ 50.00 │
│ NULL │
│ 25.00 │
└───────────────┘