题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select d.emp_no, d1.emp_no manager_no, s1.salary emp_salary, s2.salary manager_salary from dept_emp d join dept_manager d1 on d1.dept_no = d.dept_no 员工表id连接部门经理表 join salaries s1 on s1.emp_no = d.emp_no 员工表连接薪资 join salaries s2 on s2.emp_no = d1.emp_no 经理表连接薪资 where s1.salary > s2.salary 员工薪资大于经理薪资

