mysql5.6实现排名

##15. 按各科成绩进行排序，并显示排名，Score 重复时保留名次空缺
SELECT s.`c#`,s.`s#`, s.score, rank FROM
(SELECT sc.`c#`, sc.`s#`, sc.score,
CASE
when @prevRank < sc.score then @incRank:=1
else @incRank := @incRank + 1
END as nextRank,
@curRank := IF(@prevRank = sc.score, @curRank, @incRank) AS rank,
@prevRank := sc.score
FROM sc, (
SELECT @curRank :=0, @prevRank := NULL, @incRank := 0
) r
ORDER BY sc.`c#`,sc.score desc) s

 

结果集