Re: RANK() emulator?

[Rick James]

Well, another little step forward...
I think this will deal with ties, both before 10th, and on 10th. For example,

#  points:  123 111 111 77 66 55 55 55 44 33 33
#  Rank:      1   2   2  4  5  6  6  6  9 10 10 -- desired output?
#  @seq:      1   2   3  4  5  6  7  8  9 10 11 -- helper value
SELECT  @seq := 0,      -- raw 1,2,3,...
        @rank := 0,     -- rank, allowing for ties
        @prev := 999999999;  -- for catching ties
SELECT  Rank, gamer, point
    FROM (
        SELECT  @seq := @seq + 1 AS seq,
                @rank := IF(@prev = point, @rank, @seq) AS Rank,
                gamer,
                point
            FROM  (
                SELECT gamer, SUM(score) as point
                    FROM score_ranked s
                    GROUP BY  gamer
                    ORDER BY  point DESC; 
                  ) x
         ) y
    WHERE Rank <= 10
    ORDER BY Rank, gamer