Aggregate Functions

In SQL, aggregate functions perform a calculation on a set of values and return a single value. They are often used with the GROUP BY clause of the SELECT statement.

Note: Except for COUNT(*), aggregate functions ignore all NULL values.

Example

List all the years and their number of movies, but only the years with more than 5 movies:

SELECT year,
COUNT(*)
FROM movies
GROUP BY year
HAVING COUNT(*) > 5;

Aggregate Functions

AVG()
Returns the average value in a column.
COUNT()
Returns the number of rows that match the specified criteria.
MAX()
Returns the largest value in a column.
MIN()
Returns the smallest value in a column.
SUM()
Returns the sum of all the value in that column.
Edit this page on GitHub

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your feedback form.

Learn SQL on Codecademy

Edit this page on GitHub

Contributors