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;