The GROUP BY clause is used to group the identical data by one or more columns. It is used with the aggregate functions in the select statement.

Syntax:

SELECT column1, column2,…, columnN FROM tableName 
WHERE[conditions] GROUP BY column1, column2 …; 

Example:

SELECT EMP_NAME, SUM(SALARY) FROM EMPLOYEE GROUP BY EMP_NAME;

Output:

EMP_NAME	SUM(SALARY)
Nidhi	        48000
Parbhjot	81000
Parmender	90000