mysql 查询排名

表明:f_data

要获得的字段有：id，分数，排名

根据分数来排名，降序排列

SELECT id,score,
CASE 
WHEN @preRank = score THEN @curRank 
WHEN @preRank := score THEN @curRank := @curRank + 1 
END AS rank 
FROM f_data r, (SELECT @curRank := 0, @preRank := NULL ) t 
ORDER BY score DESC