Starting here? This lesson is part of a full-length tutorial in using SQL for Data Analysis. Check out the beginning.
The SQL MIN and MAX functions
MAX are SQL aggregation functions that return the lowest and highest values in a particular column.
They’re similar to
COUNT in that they can be used on non-numerical columns. Depending on the column type,
MIN will return the lowest number, earliest date, or non-numerical value as close alphabetically to “A” as possible. As you might suspect,
MAX does the opposite—it returns the highest number, the latest date, or the non-numerical value closest alphabetically to “Z.”
For example, the following query selects the
MIN and the
MAX from the numerical
volume column in the Apple stock prices dataset.
SELECT MIN(volume) AS min_volume,
MAX(volume) AS max_volume
Sharpen your SQL skills
What was Apple's lowest stock price (at the time of this data collection)?
What was the highest single-day increase in Apple's share value?