题解 | #获取员工其当前的薪水比其manager薪水高#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select e.emp_no,d.emp_no as manager_no,s1.salary as emp_salary,s2.salary as manager_salary from dept_emp e join dept_manager d on d.dept_no = e.dept_no #关联员工-经理 join salaries s1 on s1.emp_no = e.emp_no #员工工资 join salaries s2 on s2.emp_no = d.emp_no #经理工资 where s1.salary > s2.salary; #员工工资>经理工资
查看10道真题和解析