least function (Databricks SQL)

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

Syntax

least(expr1 [, ...] )

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