MySql中having语句的使用

having语句中的条件要么是查询结果的字段,要么是一个聚合函数,否则会报错.

select id,name from user where age>20 having id>10;

slect name from user where age>20 having sum(grade)>180;

SELECT sc.sno as ‘学号’, student.sname as ‘姓名’, student.sex as ‘性别’, sum(grade) as ‘总成绩’, SUM( credit ) as ‘总学分’
FROM sc
INNER JOIN student ON student.sno = sc.sno
INNER JOIN course ON course.cno = sc.cno
WHERE grade >60
GROUP BY sc.sno
HAVING SUM( credit ) >20;