MySQL GROUP BY Statement

The GROUP BY statement is used to group the records of the table(s) based on one or more column.

Its also possible to perform aggregate functions like COUNT, SUM, MIN, MAX, AVG etc. on the grouped column.

Syntax for GROUP BY Statement

SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s);

Consider the table employees with the following data.

Example query for GROUP BY

SELECT location,COUNT(empno) as count
FROM employees  
GROUP BY location;

Output

Example 2

SELECT location,COUNT(empno) as count, SUM(salary) as total_pay
FROM employees  
GROUP BY location;

This query will get the following output.

The above query will retrieve the data of employee count and total salary in that location.

Example 3

SELECT location,COUNT(empno) as count, MAX(salary) as max_salary
FROM employees  
GROUP BY location;

The above query will retrieve the employee count in the locations and the maximum salary in that location.
Output

Example 4

SELECT location,COUNT(empno) as count, AVG(salary) as avg_salary
FROM employees  
GROUP BY location;

The above query will retrieve the employee count in the locations and the average salary in that location.

Output