首先获得所有领导的名单
select e.empno,e.ename,e.sal from emp e
join
(select DISTINCT e.mgr as mgr from emp e where e.mgr is not null) e1
on e.empno = e1.mgr
order by e.sal;
然后获得所有普通员工(非领导职务)的名单
select
b.empno
首先获得所有领导的名单
select e.empno,e.ename,e.sal from emp e
join
(select DISTINCT e.mgr as mgr from emp e where e.mgr is not null) e1
on e.empno = e1.mgr
order by e.sal;
然后获得所有普通员工(非领导职务)的名单
select
b.empno