MIN Function [Aggregate]

Returns the minimum expression value found in each group of rows.

Syntax

MIN ( expression
| DISTINCT column-name )

Parameter	Description
expression	The expression for which the minimum value is to be calculated. This is commonly a column name.
DISTINCT column-name	Returns the same as MIN ( expression ), and is included for completeness.

The same data type as the argument.

The following statement returns the value 24903.000, representing the minimum salary in the Employees table:

SELECT MIN ( Salary )
FROM Employees

Rows where expression is NULL are ignored. Returns NULL for a group containing no rows.