题解 | #每类试卷得分前三名#
每类试卷得分前3名
http://www.nowcoder.com/practice/255aa1863fe14aa88694c09ebbc1dbca
SELECT tid, uid, ranking
FROM (
SELECT tag as tid, uid,
ROW_NUMBER()OVER(PARTITION BY tag ORDER BY MAX(score) DESC, MIN(score) DESC, uid DESC) AS ranking
FROM examination_info
JOIN
exam_record
USING(exam_id)
GROUP BY tag, uid
) rankable
WHERE ranking <= 3
小天才公司福利 1282人发布
