What are the statements used for grouping in mysql?

MySQL grouping statement MySQL provides the following statements for grouping data: 1. GROUP BY: Group rows by grouping key; 2. HAVING: Filter grouping results; 3. WITH ROLLUP: Create summary rows; 4. WITH CUBE: Create multidimensional summary rows.

Group Statements in MySQL

The following statements are available in MySQL to group data:

GROUP BY

The GROUP BY statement groups together rows with the same grouping key value. The grouping key can be a single column or a combination of multiple columns.

SELECT column_list
FROM table_name
GROUP BY grouping_column_list;

HAVING

The HAVING statement is used to filter grouped results. It is used with the GROUP BY statement to apply conditions on grouped data sets.

SELECT column_list
FROM table_name
GROUP BY grouping_column_list
HAVING condition;

WITH ROLLUP

WITH ROLLUP statement is used to create summary rows in a GROUP BY operation. It adds summary rows for each grouping level to the result set.

SELECT column_list
FROM table_name
GROUP BY grouping_column_list WITH ROLLUP;

WITH CUBE

The WITH CUBE statement is used to create multidimensional summary rows in a GROUP BY operation. It adds summary rows for all possible subset groupings to the result set.

SELECT column_list
FROM table_name
GROUP BY grouping_column_list WITH CUBE;

The above is the detailed content of What are the statements used for grouping in mysql?. For more information, please follow other related articles on the PHP Chinese website!