SQL代码求解问题求大神解答

select e.deptno as 部门编号 ,e.ename as 员工编号 , e.sal as 工资数额 from ( select deptno , ename,sal,row_number() over(partition by deptno order by sal desc) rn from emp ) e where e.rn <=1