SQL 中 HAVING 用法

SELECT * FROM (SELECT TeacherID, AVG(Age) AS AGE FROM Student 2 GROUP BY TeacherID) T WHERE T.AGE > 12 View Code

使用HAVING

1   SELECT TeacherID, AVG(Age) AS AGE FROM Student
2   GROUP BY TeacherID
3   HAVING AVG(Age) > 12

View Code

结果如下：

 

HAVING:给分组设置条件

 

SQL 中 HAVING 用法

标签：display   pre   .com   ini   rom   images   select   tar   lin