立即学习:https://edu.csdn.net/course/play/27328/362529?utm_source=blogtoedu
gruop by分组每个部分多少员工:
select dept,count(*) from employee group by dept;
对分组之后的组再过滤,having
选择人数小于5的部门:
select dept,count(*) from employee group by dept having count(*)<5;
立即学习:https://edu.csdn.net/course/play/27328/362529?utm_source=blogtoedu
gruop by分组每个部分多少员工:
select dept,count(*) from employee group by dept;
对分组之后的组再过滤,having
选择人数小于5的部门:
select dept,count(*) from employee group by dept having count(*)<5;