17,086
社区成员
发帖
与我相关
我的任务
分享
select id,name,item,score
from
(
select a.id ,a.name,a.item,a.score,b.rn
from a,
select ( name,
row_number() over(partition name order by score desc) rn
from a
where item= 3
) b
where a.name=b.name
order by b.rn,a.item desc)