Aggregate Functions



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.