mysql排名写法

//并列排名
SELECT score.*,
CASE
 WHEN @score = score THEN @scoreNum 
 WHEN @score := score THEN @scoreNum :=@scoreNum+1 
WHEN @score =0 THEN @scoreNum :=@scoreNum+1 
END AS scoreNum 
FROM score,
(SELECT @scoreNum :=0,@score :=NULL) init  
ORDER BY score DESC

//排名统计方式   递增
SELECT pid, NAME, age, @curRank := @curRank + 1 AS rank
FROM players p, (
SELECT @curRank := 0
) q
ORDER BY age

//实践笔记