least function

Applies to: check marked yes Databricks SQL check marked yes 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