1:having和where都是用来查询条件的筛选;
2:having是建立在分组后的查询条件(也就是说有having的sql语句,前面必有group by);
3:having可以视为对where查询条件的补充;
4:在查询次序上优先级顺序的不同:子句 > from > where > group by > 聚合函数 > having > ordery;
例:查询出所有科目都及格的学生编号
SELECT sc.`sid`,MIN(sc.`grade`)m FROM sc GROUP BY sc.`sid` HAVING m>60;
(注:语句按照执行顺序select>from>group by>min()>having