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; |