SQL MIN() and MAX()
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() Syntax
SELECT MIN(column_name)
FROM table_name
WHERE condition;
MAX() Syntax
SELECT MAX(column_name)
FROM table_name
WHERE condition;
Demo Database
Below is a selection from the "Products" table in the Northwind sample database:

MIN() Example
The following SQL statement finds the price of the cheapest product
Example
SELECT MAX(Price) AS LargestPrice
FROM Products;
Last updated
Was this helpful?