题解 | 获取员工其当前的薪水比其manager当前薪水还高
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
SELECT d_e.emp_no, d_m.emp_no, s.salary, sa.salary
FROM dept_emp as d_e
LEFT JOIN dept_manager as d_m
ON d_e.dept_no = d_m.dept_no
LEFT JOIN salaries as s
ON d_e.emp_no = s.emp_no
LEFT JOIN salaries as sa
ON d_m.emp_no = sa.emp_no
WHERE d_e.emp_no not in (
SELECT emp_no
FROM dept_manager
)
and
s.salary > sa.salary
查看5道真题和解析
投递携程等公司10个岗位
