题解 | 获取每个部门中薪水最高的员工相关信息
获取每个部门中薪水最高的员工相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select r.dept_no,r.emp_no,r.salary from( select rank()over(partition by dept_no order by salary desc) ranking,salary,d.emp_no,d.dept_no from dept_emp d join salaries s on d.emp_no= s.emp_no ) r where r.ranking=1#窗口函数##sql刷题#
