MySQL-在最高得分列表中排名用户

对于8.0之前的版本…

SELECt *  FROM      ( SELECt a.* , @i := @i+1 i         FROM my_table a         JOIN (SELECT @i:=0) vars        ORDER BY highscore DESC , userid      ) x WHERe name = 'jennie'    OR i <= 3     ORDER         BY i;

https://www.db-fiddle.com/f/hYsiCE1bXeTnR2HzoJkKiR/0