题解 | #获取每个部门中当前员工薪水最高的相关信息#
获取每个部门中当前员工薪水最高的相关信息
http://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
with combine as ( SELECT x.emp_no,x.dept_no,y.salary from dept_emp as x join salaries as y on x.emp_no = y.emp_no) select dept_no,emp_no,salary as maxSalary from( select emp_no,dept_no,salary, ROW_NUMBER() over(partition by dept_no order by salary desc) as rt from combine) as t where rt = 1;
投递小米集团等公司7个岗位