现在 Student表有 如下数据
现需求如下： 查找每个⽼师的学⽣的平均年龄且平均年齿⼤于12不使⽤ HAVING
1 SELECT * FROM (SELECT TeacherID, AVG(Age) AS AGE FROM Student2 GROUP BY TeacherID) T WHERE T.AGE > 12
View Code使⽤HAVING
1 SELECT TeacherID, AVG(Age) AS AGE FROM Student2 GROUP BY TeacherID3 HAVING AVG(Age) > 12
View Code结果如下：
HAVING:给分组设置条件
因篇幅问题不能全部显示，请点此查看更多更全内容