MySQL Group By Clause

Group By Statement:

The MySQL Group by clause is used to display the rows and columns grouped by selective columns. It can be used to perform the aggregate functions, such as count().

Example :

The following example query will list the name of the student and also count the repeative names using Group By Statement. The below query will display the name and sum of marks of the student using MySQL group by clause. The above examples shows how to use the MySQL Group by clause in the select statement.