least function

Applies to: Databricks SQL Databricks Runtime

Returns the least value of all parameters, skipping null values.

Syntax

least(expr1, expr2 [, ...] )

Arguments

• exprN: An expression of any type that shares a least common type with all other arguments.

Returns

The result is the least common type of all arguments.

Examples

> SELECT least(10, 9, 2, 4, 3);
 2

Related

• greatest function
• SQL data type rules