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:
