应用场景解析:
一般如果SQL语句中同时出现Where和Group By子句,一般是Where在前,Group By在中,Having在后。
where筛选是在分组之前筛选,筛选完之后再group by
having是分组之后再筛选,筛选完之前先group by
所以总的顺序是:Where > Group by > Having
例:要求查询选了四门及以上的课程的学生(达到60分才算一门)
Student(Sno, Sname, Sage, Ssex, Sdept)
Course(Cno, Cname, Cdept, Credit)
SC(Sno, Cno, Grade)
>>>
SELECT Sno, Count(*)
FROM SC
WHERE Grade >= 60 /* 先筛选掉低于60分的学生成绩记录*/
GROUP BY Sno
HAVING Count(*) >= 4; /* 后筛选掉少于4门的学生课程组别*/