mysql与group by和having

参考：https://www.2cto.com/database/201712/706595.html

 

顺序为：

开始->where 行记录筛选-.>group by分组->聚合函数(sum,max,min)计算，-> having分组筛选->结束

 

mysql> select CLASS, SNAME from student_score group by CLASS;
+-------+-------+
| CLASS | SNAME |
+-------+-------+
| 3班   | 3班1  |
| 一班  | 1班1  |
| 二版  | 2班1  |
+-------+-------+
3 rows in set (0.04 sec)

 

mysql> SELECT CLASS,SUM(TOTAL_SCORES) FROM student_score GROUP BY CLASS;
+-------+-------------------+
| CLASS | SUM(TOTAL_SCORES) |
+-------+-------------------+
| 3班   |               110 |
| 一班  |               400 |
| 二版  |               350 |
+-------+-------------------+
3 rows in set (0.04 sec)

 

mysql> sELECT CLASS,SUM(TOTAL_SCORES) FROM student_score GROUP BY CLASS HAVING SUM(TOTAL_SCORES)>200;
+-------+-------------------+
| CLASS | SUM(TOTAL_SCORES) |
+-------+-------------------+
| 一班  |               400 |
| 二版  |               350 |
+-------+-------------------+
2 rows in set (0.07 sec)