iff function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns expr1 if cond is true, or expr2 otherwise. This function is a synonym for if function.

Syntax 

iff(cond, expr1, expr2)

Arguments

  • cond: A BOOLEAN expression.

  • expr1: An expression of any type.

  • expr2: An expression that shares a least common type with expr1.

Returns

The result is the common maximum type of expr1 and expr2.

Examples 

> SELECT iff(1 < 2, 'a', 'b');
 a