1. 用途
根据一个或多个列对结果集进行分组
2. 可以在分组的列上使用的函数
SUM,COUNT,AVG
3… 案例
SELECT age, COUNT(age) as age_count FROM students where class=1 GROUP BY age;
从学生中找出1班的学生,按年龄分组,并统计每个年龄的学生数量
4. WITH ROLLUP的用法
可以在实现分组的数据上进行统计(SUM,COUNT,AVG),比如:
SELECT age, COUNT(age) as age_count, AVG(grades) FROM students where class=1 GROUP BY age WITH ROLLUP;