MIN and MAX

Get the smallest and largest values.

MIN and MAX

MIN returns the smallest, MAX the largest value. Works on numbers, text and dates.

SELECT MIN(price), MAX(price) FROM products;

This query gives the lowest and highest price.

MIN(price), MAX(price) is selected from products.

MIN and MAX — details

MIN and MAX skip NULLs. For text they follow alphabetical order.

For example, MIN(created_at) gives the date of the first record and MAX(created_at) the last; MIN(name) returns the name that comes first alphabetically.

Exercise MIN and MAX

Find the lowest price in products with MIN(price).

Show example solution

SELECT MIN(price) FROM products;

Test yourself

What does MIN return?
- The largest value
- The smallest value
- The average
- The total
Show answer

The smallest value — MIN returns the smallest value.

Add MIN

SELECT ____(price) FROM products;

Show answer

SELECT MIN(price) FROM products;

MIN and MAX: match the terms

MIN

smallest
MAX

largest
NULL

skip
text

alphabet

Next lesson: NULL and aggregates

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies