题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select d.emp_no,d.manager_no,d.emp_salary,d.manager_salary
from
(select c.emp_no,c.manager_no,c.salary emp_salary,s2.salary manager_salary
from
(select a.emp_no,b.emp_no manager_no,s1.salary
from dept_emp a
inner join dept_manager b
on a.dept_no=b.dept_no
inner join salaries s1
on a.emp_no=s1.emp_no
where a.emp_no<>b.emp_no) c
left join salaries s2
on c.manager_no=s2.emp_no) d
where d.emp_salary>d.manager_salary;
