SQL GROUP BY clause

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