Finding the minimum and maximum values using MIN and MAX functions.
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