SELECT子句及其顺序:
SELECT -- FROM -- WHERE -- GROUP BY -- HAVING -- ORDER BY -- LIMIT
HAVING 用于GROUP BY之后,常一起搭配使用。
HAVING 是在GROUP BY 分组之后的二次筛选。
栗子:
代码:
select title,count(title) as t from titles group by title having t>=2;
代码;
select title, count( distinct emp_no ) as t from titles group by title having t>=2;