# 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:

### Example

SELECT MIN(Price) AS SmallestPrice
FROM Products;
Try it Yourself »

## 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.

## Exercise:

Use the `MIN` function to select the record with the smallest value of the `Price` column.

```SELECT
FROM Products;
```

Start the Exercise

×

## Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com