The MIN() Function
The MIN() function returns the smallest value of the selected column.
SQL MIN() Syntax
SELECT MIN(column_name) FROM table_name;
SQL MIN() Example
The following SQL statement gets the smallest value of the “Price” column from the “Products” table:
Example
SELECT MIN(Price) AS SmallestOrderPrice FROM Products;