Using the Group Functions

What Are Group Functions ?

• Group functions operate on sets of rows to give one result per group.

Types of Group Functions :

• AVG
• COUNT
• MAX
• MIN
• SUM

Group Functions : Syntax

• SELECT [column,] group_function(column), ... FROM table [WHERE condition] [GROUP BY column] [ORDER BY column];