Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Updated Nov 20, 2024
Send us feedback
least
Applies to: Databricks SQL Databricks Runtime
Returns the least value of all parameters, skipping null values.
least(expr1, expr2 [, ...] )
exprN: An expression of any type that shares a least common type with all other arguments.
exprN
The result is the least common type of all arguments.
> SELECT least(10, 9, 2, 4, 3); 2
greatest function
SQL data type rules