Re: RANK() emulator?
This solution may drag with 20,000 users, but you can give it a go...
SELECT rank
, GROUP_CONCAT(gamer)
, score
FROM
( SELECT t1.*
, COUNT(*) rank
FROM score_ranked t1
JOIN score_ranked t2
ON t1.score < t2.score
OR t1.gamer = t2.gamer
GROUP
BY gamer
HAVING rank <= 10
) x
GROUP
BY score
ORDER
BY rank;
Subject
Written By
Posted
September 21, 2009 01:25PM
September 21, 2009 01:33PM
September 21, 2009 02:09PM
September 21, 2009 04:23PM
November 07, 2009 10:27AM
Re: RANK() emulator?
November 11, 2009 03:18PM
November 08, 2009 03:52PM
November 09, 2009 10:56AM
November 09, 2009 04:42PM
November 09, 2009 05:38PM
November 09, 2009 08:18PM
November 10, 2009 06:21PM
November 10, 2009 09:22PM
November 11, 2009 09:19AM
November 11, 2009 08:36PM
November 12, 2009 08:39AM
November 12, 2009 08:00PM
November 13, 2009 06:41PM
November 17, 2009 10:35PM
November 19, 2009 10:35AM
November 17, 2009 10:38PM
November 19, 2009 10:16AM
November 19, 2009 10:32AM
November 19, 2009 10:39AM
November 19, 2009 10:45AM