MySQL: GROUP BY Clause

This MySQL tutorial explains how to use the MySQL GROUP BY clause with syntax and examples.

The MySQL GROUP BY clause is used in a SELECT statement to collect data across multiple records and group the results by one or more columns.

The syntax for the GROUP BY clause in MySQL is:

Example – Using SUM function

Let’s look at a MySQL GROUP BY query example that uses the SUM function.

This MySQL GROUP BY example uses the SUM function to return the name of the product and the total quantity (for the product).

SELECT product, SUM(quantity) AS "Total quantity"FROM order_detailsGROUP BY product;

Because you have listed one column (the product field) in your SELECT statement that is not encapsulated in the SUM function, you must use the GROUP BY Clause. The product field must, therefore, be listed in the GROUP BY clause.