MySQL，获取用户排名

SELECt  uo.*,         (        SELECT  COUNT(*)        FROM    users ui        WHERe   (ui.points, ui.id) >= (uo.points, uo.id)        ) AS rankFROM    users uoWHERe   id = @id

密集等级：

SELECt  uo.*,         (        SELECT  COUNT(DISTINCT ui.points)        FROM    users ui        WHERe   ui.points >= uo.points        ) AS rankFROM    users uoWHERe   id = @id