Question

What is the functions of Group By clause and Order By clause.

Answer 1

Explanation:

The group by clause is a SQL command that is used to group rows that have the same values .

The group by clause is used in the select statement. Optionally it is used in conjunction with aggregate functions to produce summary reports from the database .