怎么样实现分组取前Noracle账号条记录
如获取每个部门薪水前三名的员工或每个班成绩前三名的学生。
Select * from (select depno,ename,sal,row_number() over (partition by depno order by sal desc) rn from emp) where rn<=3
怎么样实现分组取前Noracle账号条记录
如获取每个部门薪水前三名的员工或每个班成绩前三名的学生。
Select * from (select depno,ename,sal,row_number() over (partition by depno order by sal desc) rn from emp) where rn<=3