Calculates the minimum value of an expression across all input values.
|Supported input types
|The expression used to calculate the minimum value
|Any string, numeric or date/timestamp type
Valid values for the expression include a column name or functions that return a column name.
Same as input type
For this example, see the following table,
|The Drift Championship
|The Lost Track Showdown
|The Acceleration Championship
|The French Grand Prix
|The Circuit Championship
When used on the
MIN will return the smallest value.
MIN(totalprizedollars) as minprize
MIN can also work on text columns by returning the text row with the characters that are first in the lexicographic order. In this example, the function assesses the
name column in the
MIN(name) as mintournament
The Acceleration Championship