Returns the minimum value in its argument. NULL values are ignored. If all inputs are NULL, MIN returns NULL.

​
Syntax

MIN(<expression>)

​
Parameters

ParameterDescriptionSupported input types
<expression>The expression whose minimum to determineAny type

​
Return Types

Same as input type

​
Examples

Example This code example uses the following tournaments table:
nametotalprizedollars
The Drift Championship22,048
The Lost Track Showdown5,336
The Acceleration Championship19,274
The French Grand Prix237
The Circuit Championship9,739
When used on the totalprizedollars column, MIN will return the smallest value. 
SELECT
	MIN(totalprizedollars) as minprize
FROM
	tournaments;
Returns 237 MIN can also work on text or array columns, in which case it returns the lexicographically smallest value. In this example, the function assesses the name column in the tournaments table. 
SELECT
	MIN(name) as mintournament
FROM
	tournaments;
Returns The Acceleration Championship