# 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

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.