the group by clause in sql

SQL GROUP BY Statement  is used to arrange identical data into groups with the help of Aggregate functions.