题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
# 获取员工其当前的薪水比其manager当前薪水还高的相关信息
select
t1.emp_no,
t1.manager_no,
s.salary emp_salary,
s1.salary manager_salary
from (
# 员工和上司
select
de.emp_no,
dm.emp_no manager_no
from dept_emp de
left join dept_manager dm
on de.dept_no = dm.dept_no
where dm.emp_no != de.emp_no
)t1
left join salaries s
on t1.emp_no = s.emp_no
left join salaries s1
on t1.manager_no = s1.emp_no
where s.salary > s1.salary;
查看21道真题和解析