需求四:统计实现每个部门员工薪资最高的前2名 分析: 出现每个:分区还是分组? 分区 select * from ( select empno, ename, salary, deptno, row_number() over (partition by deptno order by salary desc) as rn from tb_emp ) tmp where tmp.rn < 3;