Re: RANK() emulator?

[Rick James]

If you don't have the SUM(score), better get it first:

SELECT  @rank := 0; 
SELECT  @rank := @rank + 1 AS Rank, gamer,
        point
    FROM  (
        SELECT gamer, SUM(score) as point
            FROM score_ranked s
            GROUP BY  gamer
            Order By  point DESC; 
          ) x

Do deal with ties for 10th place, perhaps you need to fetch all the rows, but have the application code decide when to stop reading rows.

To do it entirely in MySQL probably involves creating a temporary table, finding the 10th 'point', then fetching all the rows that have that value or more. This would get 10 or more rows appropriately.