如题 ...................

试试下面的语句看：
select a.deptno
from (select deptno, count(*) as total
               from emp group by deptno ) a,
        (select deptno, count(*) as total
               from emp group by deptno ) b
where a.total=b.total and a.deptno!=b.deptno;