select b.deptno, count(empno) from emp a, dept b where a.deptno(+)=b.deptno and a.job(+)='MANAGER' group by b.deptno;
博客园 © 2004-2025 浙公网安备 33010602011771号 浙ICP备2021040463号-3