题解 | #获取每个部门中当前员工薪水最高的相关信息#
获取每个部门中当前员工薪水最高的相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select t.dept_no, t.emp_no,t.salary from (select c.dept_no, c.emp_no , c.salary , row_number () over (partition by c.dept_no order by c.salary desc ) as rk from (select a.emp_no,a.dept_no,b.salary from dept_emp a left join salaries b on a.emp_no =b.emp_no) c)t where t.rk =1
