Lesson 20: Finding the minimum and maximum values using MIN and MAX functions.

By Alan Hylands — 1 minute read

Highest.

If we want to find out what the highest value within a specified column is, we use the MAX function. This gives us the MAXIMUM value. Like this,

SELECT MAX(IntlCaps)
FROM Footballers;

Lowest.

If we want to find out what the lowest value within a specified column is, we use the MIN function. This gives us the MINIMUM value. For example,

SELECT MIN(IntlCaps)
FROM Footballers;
Try the next lesson