获取员工其当前的薪水比其manager当前薪水还高的信息
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
SELECT
de.emp_no,
dm.emp_no AS manager_no,
s1.salary AS emp_salary,
s2.salary AS manager_salary
FROM dept_emp AS de
INNER JOIN salaries AS s1 ON de.emp_no = s1.emp_no
INNER JOIN dept_manager AS dm ON de.dept_no = dm.dept_no
INNER JOIN salaries AS s2 ON dm.emp_no = s2.emp_no
WHERE s2.salary < s1.salary;
还有比这个更简洁的吗？
