题解 | #每类试卷得分前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;
投递华为HUAWEI等公司10个岗位
