--用row_number() over()select id,name,score from (select id,name,score,row_number() over(partition by name order by score desc) as fnum from 表A) t where t.fnum<= 3
有问题可以追问
