GROUP BY 语句用于结合聚合函数,根据一个或多个列对结果集进行分组。
SELECT class.institute,SUM(class.grade) AS sum
FROM class
GROUP BY class.institute
在 SQL 中增加 HAVING 子句原因是,WHERE 关键字无法与聚合函数一起使用。
HAVING 子句可以让我们筛选分组后的各组数据。
SELECT class.institute,SUM(class.grade) AS sum
FROM class
GROUP BY class.institute
HAVING SUM(class.grade)>10000