题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
SELECT d.emp_no,dm.emp_no,s1.salary emp_salary,s2.salary manager_salary
from dept_emp d left join dept_manager dm on d.dept_no=dm.dept_no
left join salaries s1 on d.emp_no=s1.emp_no
left join salaries s2 on dm.emp_no=s2.emp_no
where d.to_date='9999-01-01'
and s2.salary<s1.salary