SQL MIN() and MAX() Functions
The SQL MIN() and MAX() Functions
The MIN() function returns the smallest value of the selected column.
The MAX() function returns the largest value of the selected column.
MIN Example
Find the lowest price in the Price column:
SELECT MIN(Price)
FROM Products;
Try it Yourself »
MAX Example
Find the highest price in the Price column:
SELECT MAX(Price)
FROM Products;
Try it Yourself »
Syntax
SELECT MIN(column_name)
FROM table_name
WHERE condition;
SELECT MAX(column_name)
FROM table_name
WHERE condition;
Demo Database
Below is a selection from the Products table used in the examples:
| 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 |
Set Column Name (Alias)
When you use MIN() or
MAX(), the returned column will not have a
descriptive name. To give the column a descriptive name, use the
AS keyword:
Use MIN() with GROUP BY
Here we use the MIN() function and the
GROUP BY clause, to return the smallest price
for each category in the Products table:
Example
SELECT MIN(Price) AS SmallestPrice, CategoryID
FROM Products
GROUP BY CategoryID;
Try it Yourself »
You will learn more about the
GROUP BY clause later in this tutorial.
