These functions are used for aggregating column data together. They are used with a SELECT's GROUP BY clause. Where all of the GROUP BY columns for a number of rows are equal, one row is returned, and all of the non-group by columns that would be returned can be processed by these grouping (or aggregation) functions.

• COUNT
• SUM
• AVG
• MIN
• MAX

Related

• SQL Reference
• SQL Functions and Operators