SQL · Aggregation and grouping

min() / max()

Returns the smallest or largest non-null value.

sqlRunnable example sql course

Syntax

min(column)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20), (30))
SELECT min(minutes), max(minutes) FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.