怎么样实现分组取前N条记录

Select * from 

(select depno,ename,sal,row_number() over (partition by depno 

order by sal desc) rn 

from emp) 

where rn<=3