Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

least(...)

least(...)

Returns the smallest value among its arguments, ignoring NULLs.

Works with the following datatypes:

This function works with 2.1 and 3.0 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:

The TryIt macro has been disabled until future notice while we upgrade this site to SODA3.

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