Mark As Completed Discussion

What Are Aggregate Functions?

An aggregate function is a function that's applied on multiple values, and returns a single value after the calculation. In SQL, there are multiple aggregate functions. The most commonly used ones are:

  • MIN()
  • MAX()
  • SUM()
  • AVG()
  • COUNT()

Each of these functions are applied on columns. Let's investigate the operation of each, one by one. All queries are written referring to the following table:

What Are Aggregate Functions?