having子句对我们筛选分组后的数据非常方便
语法:
group by 字段 having 条件判断;
SELECT dept,COUNT(user_name) count_tmp FROM table GROUP BY dept HAVING count_tmp >1;
注意:having后面跟的条件判断的字段必须是聚合函数返回的结果,否则sql会报错:
having子句对我们筛选分组后的数据非常方便
语法:
group by 字段 having 条件判断;
SELECT dept,COUNT(user_name) count_tmp FROM table GROUP BY dept HAVING count_tmp >1;
注意:having后面跟的条件判断的字段必须是聚合函数返回的结果,否则sql会报错: