The MIN() function retrieves the smallest value from the selected column.
The MAX() function retrieves the largest value from the selected column.
SELECT MIN(column_name) FROM table_name WHERE condition; |
SELECT MAX(column_name) FROM table_name WHERE condition; |
Below is a selection from the “Products” table in the Northwind sample database:rephrase
ProductID |
ProductName |
SupplierID |
CategoryID |
Unit |
Price |
1 |
Chais |
1 |
1 |
10 boxes x 20 bags |
18 |
2 |
Chang |
1 |
1 |
24 – 12 oz bottles |
19 |
3 |
Aniseed Syrup |
1 |
2 |
12 – 550 ml bottles |
10 |
4 |
Chef Anton’s Cajun Seasoning |
2 |
2 |
48 – 6 oz jars |
22 |
5 |
Chef Anton’s Gumbo Mix |
2 |
2 |
36 boxes |
21.35 |
The following SQL statement retrieves the price of the cheapest product:
SELECT MIN(Price) AS SmallestPrice FROM Products; |
The following SQL statement retrieves the price of the most expensive product:
SELECT MAX(Price) AS LargestPrice FROM Products; |