if function

Applies to: Databricks SQL Databricks Runtime

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

Syntax

if(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 if(1 < 2, 'a', 'b');
 a

Related functions

• case expression
• decode (key) function
• iff function