least(...)
Returns the smallest value among its arguments, ignoring NULLs.
Works with the following datatypes:
This function works with 2.1 endpoint(s). What does this mean? »
The least(...)
function is used to find the smallest among a collection of values. For example, find the earlier of the date
and updated_on
columns in Chicago Crimes:
https://data.cityofchicago.org/resource/6zsd-86xi.json?$select=least(date,updated_on)
Note that to find the smallest value in a set of rows grouped by a GROUP BY
clause, use min
instead.