题解 | #每类试卷得分前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;
投递优酷等公司10个岗位 >
，日常实习的话建议还是写上去吧，实习经历还是挺重要的，虽然是crud但是你包装一下也是可以的