题解 | 获取每个部门中薪水最高的员工相关信息
获取每个部门中薪水最高的员工相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select c.dept_no,c.emp_no,c.salary from (select a.dept_no,a.emp_no,b.salary, dense_rank() over (partition by dept_no order by salary desc) as rk from (dept_emp as a left join salaries as b on a.emp_no=b.emp_no)) as c where c.rk=1 order by c.dept_no
先合并两个表，然后增加一列排名，再抽取排名为1的数据，最后排序
题目并没有要求筛选是否在职，个人觉得再筛一次to_date的意义不大
