Aggregate functions

Aggregate functions return the average (AVG), count (COUNT), maximum value (MAX), minimum value (MIN) or sum (SUM) of a set of values or the number of rows in a derived table.

The aggregate functions MIN() and MAX() reference the set of all values in a column in a table. They differ in this way from a CASE expression with MIN / MAX (see "CASE expression"), which references different expressions.