Explain the use of group by clause

- "Group By" is used to derive aggregate values by grouping similar data.

Explain the use of group by clause.

GROUP BY clause used in SELECT statement for retrieving data from a set of records and group the results in one or more columns. It divides the set of records into sets. The GROUP BY clause fetches the rows of a table into groups, which contains identical column values.