Link Search Menu Expand Document

MIN

Calculates the minimum value of an expression across all input values.

Syntax

MIN(<expression>)

Parameters

Parameter Description Supported input types
<expression> 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.

Return Types

Same as input type

Example

For this example, see the following table, tournaments:

name totalprizedollars
The Drift Championship 22,048
The Lost Track Showdown 5,336
The Acceleration Championship 19,274
The French Grand Prix 237
The Circuit Championship 9,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 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 tournaments table.

SELECT
	MIN(name) as mintournament
FROM
	tournaments;

Returns: The Acceleration Championship