Reporting Aggregated Data Using the Group Functions

Unlike single row functions,groups functions operate on set of rows to give a result per group,Sets may comprise the entire table into groups.

There are following types of groups functions:

1. AVG
2. MAX
3. MIN
4. COUNT
5. STDDEV
6. VARIANCE

SUM