题解 | #获取每个部门中当前员工薪水最高的相关信息#
获取每个部门中当前员工薪水最高的相关信息
http://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select dept_no ,emp_no ,maxSalary from (select a.dept_no ,a.emp_no ,b.salary as maxSalary ,DENSE_RANK() over(partition by a.dept_no order by b.salary desc ) as rn from dept_emp a join salaries b on (a.emp_no=b.emp_no) ) t1 where rn = 1 order by dept_no asc
正浩创新EcoFlow公司福利 644人发布