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:


Note that to find the smallest value in a set of rows grouped by a GROUP BY clause, use min instead.