MIN

MIN (expression)

Parameters

• expression - may be a column name, the result of another function, or a math operation.

Description

Returns the lowest value. If no entries are selected, the result is NULL. Aggregates are only allowed in select statements. The returned value is of the same data type as the parameter.

Example

Get an age of the youngest player:

SELECT MIN(age) FROM Players;