题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://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 de
join dept_manager dm
on de.dept_no = dm.dept_no
join salaries s1
on de.emp_no = s1.emp_no
join salaries s2
on dm.emp_no = s2.emp_no
where s1.salary > s2.salary;
投递小红书等公司10个岗位 >
查看9道真题和解析