SQL Min and Max

The SQL MIN() and MAX() Functions

The smallest number in the chosen column is returned by the MIN() method.

The greatest value in the chosen column is returned by the MAX() method.

Find the lowest price in the Price column:

				
					SELECT MIN(Price)
FROM Products;

Find the highest price in the Price column:

				
					SELECT MAX(Price)
FROM Products;

				
					SELECT MIN(column_name)
FROM table_name
WHERE condition;

				
					SELECT MAX(column_name)
FROM table_name
WHERE condition;

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 returned column will not have a descriptive name when you use MIN() or MAX(). Use the AS keyword to provide a meaningful name for the column:

				
					SELECT MIN(Price) AS SmallestPrice
FROM Products;

Here, we retrieve the lowest price for every category in the Products table using the MIN() method and the GROUP BY clause:

				
					SELECT MIN(Price) AS SmallestPrice, CategoryID
FROM Products
GROUP BY CategoryID;