题解 | 查询员工薪资>manager_salary
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select dee.emp_no, dem.emp_no as manager_no , es.salary as emp_salary, ms.salary as manager_salary from dept_emp as dee join dept_manager as dem on dee.dept_no=dem.dept_no left join salaries as es on dee.emp_no=es.emp_no left join salaries as ms on dem.emp_no= ms.emp_no where dee.emp_no<> dem.emp_no and es.salary>ms.salary;#记录#
查看12道真题和解析
投递小米集团等公司10个岗位