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.