题解 | #每类试卷得分前3名#
每类试卷得分前3名
https://www.nowcoder.com/practice/255aa1863fe14aa88694c09ebbc1dbca
select *
from (
select tag as tid,
uid,
row_number() over (partition by tag order by MAX(score) desc,min(score) desc ,uid desc) ranking
from exam_record
join examination_info ei on exam_record.exam_id = ei.exam_id
group by tag, uid
)t
where ranking <=3;
腾讯成长空间 5981人发布
查看2道真题和解析