What is the significance of using multiple columns in MySQL GROUP BY clause?

By specifying multiple columns in GROUP BY clause we can split the result set into smaller groups. The more columns specified in GROUP BY clause, the smaller the groups will be.

Example

mysql> Select designation, YEAR(Doj), count(*) from employees GROUP BY designation, YEAR(DoJ);

+-------------+-----------+----------+
| designation | YEAR(Doj) | count(*) |
+-------------+-----------+----------+
| Asso.Prof   | 2013      | 1        |
| Asst.Prof   | 2015      | 1        |
| Asst.Prof   | 2016      | 1        |
| Prof        | 2009      | 2        |
| Prof        | 2010      | 1        |
+-------------+-----------+----------+

5 rows in set (0.00 sec)

Ankith Reddy

Published on 19-Feb-2018 11:49:09

• Related Questions & Answers
• Can we use MySQL GROUP BY clause with multiple columns like MySQL DISTINCT clause is used?
• What is the benefit of using MySQL SUM() function with GROUP BY clause?
• MySQL query to GROUP BY multiple columns
• Using GROUP BY and MAX on multiple columns in MySQL?
• What is the use of ORDER BY clause in MySQL?
• How Can MySQL GROUP BY clause behave like DISTINCT clause?
• MySQL filtering by multiple columns?
• What is an Acceleration Clause and what is its significance?
• How to use MySQL DISTINCT clause on multiple columns?
• GROUP BY the number of rows returned by GROUP BY in MySQL?
• In a Multiple-line query, what is the significance of the change of MySQL prompt after the first line?
• Insert multiple data using SET clause in MySQL?
• Limit the count using GROUP BY in MySQL
• How to order or choose rows in MySQL GROUP BY clause?
• What is the significance of Hampi Monuments?