题解 |获取员工其当前的薪水比其manager当前薪水高信息
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select d.emp_no ,de.emp_no,s1.salary,s2.salary from dept_emp d left join dept_manager de on d.dept_no=de.dept_no left join salaries s1 on d.emp_no=s1.emp_no left join salaries s2 on de.emp_no=s2.emp_no where de.emp_no != d.emp_no and s1.salary>s2.salary