mysql> select s1.*,(select count(0) + 1 from score s2 where s2.score > s1.score)rank from score s1;
https://blog.youkuaiyun.com/jslcylcy/article/details/72627762
mysql> select s1.*,(select count(0) + 1 from score s2 where s2.score > s1.score)rank from score s1;
https://blog.youkuaiyun.com/jslcylcy/article/details/72627762