select deptno as 部门,count(*) as 人数from emp group by deptno; 转载于:https://www.cnblogs.com/hyx0920/p/7171559.html