Group by clause

The Group by clause can be used in select statement to collect data across multiple records and group the results by one or more columns. This clause is most often combined with aggregate functions that produce summary values.