select * from (select Row_Number() over (partition by id order by score desc) rownum,* from class ) Total_Score where rownum <3
解释:首先根据id进行分区,在此基础上再对score进行降序排列。
select * from (select Row_Number() over (partition by id order by score desc) rownum,* from class ) Total_Score where rownum <3
解释:首先根据id进行分区,在此基础上再对score进行降序排列。