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:
- AVG
- MAX
- MIN
- COUNT
- STDDEV
- VARIANCE
SUM