题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
SELECT
e.emp_no AS emp_no,
dm.emp_no AS manager_no,
e.salary AS emp_salary,
mg.salary AS manager_salary
FROM
salaries e
INNER JOIN dept_emp de on e.emp_no=de.emp_no
INNER JOIN dept_manager dm on dm.dept_no=de.dept_no
INNER JOIN salaries mg on mg.emp_no=dm.emp_no
WHERE
e.salary > mg.salary;
