MySQL Group By
Group By clause is used to group the result set by one or more column.
Suppose we have students table as follows -
When we count number of students, we will get this output -
SELECT COUNT(*) FROM students;
But what if we want to get the students count based on their age. For this we are using GROUP BY clause. The statement is as follows -
SELECT age, count(*) FROM students GROUP BY age;