select
class,id,
name
,score,rn
from
(
,score,
row_number() over(partition
by
class
order
score
desc
)
‘rn‘
学生总表) t
where
t.rn<=5
取每个班前5名成绩的sql
原文：https://www.cnblogs.com/kzd666/p/13859289.html
