Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn
Aggregate Functions

Max / Min

The MAX and MIN functions return the highest and lowest values in a column, respectively.

How many downloads does the most popular app have?

SELECT MAX(downloads) FROM fake_apps;

The most popular app has 31,090 downloads!

MAX takes the name of a column as an argument and returns the largest value in that column. Here, we returned the largest value in the downloads column.

MIN works the same way but it does the exact opposite; it returns the smallest value.

Report a Bug
If you see a bug or any other issue with this page, please report it here.