Learn

Aggregate Functions

Congratulations!

You just learned how to use aggregate functions to perform calculations on your data. What can we generalize so far?

`COUNT`

counts the number of rows.`SUM`

returns the sum of all the values.`MAX`

/`MIN`

get the largest/smallest value.`AVG`

returns the average value.`ROUND`

round the values in a column.

*Aggregate functions* combine multiple rows together to form a single value of more meaningful information.

`GROUP BY`

is a clause used with aggregate functions to combine data from one or more columns.`HAVING`

limit the results of a query based on an aggregate property.

Report a Bug

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

Learn

Report a Bug

Learn

Report a Bug