题解 | #两次联结薪水表#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
两次联结薪水表，将员工和manager的薪水合并到一行再比较即可。
select
de.emp_no emp_no,
dm.emp_no manager_no,
s1.salary emp_salary,
s2.salary manager_salary
from dept_emp de
inner join dept_manager dm on dm.dept_no = de.dept_no
inner join salaries s1 on s1.emp_no = de.emp_no
inner join salaries s2 on s2.emp_no = dm.emp_no
where s1.salary > s2.salary;
查看26道真题和解析