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