MIN Function

The MIN function returns the lowest value in the column or expression. Using the DISTINCT keyword does not change the results. The following example finds the least expensive item in the stock table:

SELECT MIN(unit_price) FROM stock

NULL values are ignored unless every value in the column is NULL. If every column value is NULL, the MIN function returns a NULL for that column.