mode helix
NOW LIVEWork faster with Calculated Fields in Mode!Try it now


Starting here? This lesson is part of a full-length tutorial in using SQL for Data Analysis. Check out the beginning.

In this lesson we'll cover:

The SQL MIN and MAX functions

MIN and 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
  FROM tutorial.aapl_historical_stock_price

Sharpen your SQL skills

Practice Problem

What was Apple's lowest stock price (at the time of this data collection)?

Try it out See the answer

Practice Problem

What was the highest single-day increase in Apple's share value?

Try it out See the answer

Next Lesson


Looks like you've got a thing for cutting-edge data news.

Get the latest.

Get started