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