题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select de.emp_no,dm.emp_no,s1.salary,s2.salary
from dept_emp as de
join dept_manager as dm
join salaries as s1
join salaries as s2
where s1.salary > s2.salary
and de.emp_no = s1.emp_no
and de.dept_no=dm.dept_no
and de.emp_no!=dm.emp_no
and dm.emp_no = s2.emp_no
and大法
投递众安保险等公司9个岗位 >