以学生成绩排序为例:
select name,score,class,row_number() over (partition by class order by score desc) rn from sc
select * from
(
select name,score,class,row_number() over (partition by class order by score desc) rn from sc
)where rn =1;
查询结果:
查询到的结果是每个班级成绩最高的同学,每个班级返回一行结果