Re: RANK() emulator?
Posted by:
Tom Grant
Date: November 19, 2009 10:45AM
Rick
That worked great!!!!!
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 := IF(@prev = point, @seq, @seq + 1) AS seq, ## CHANGED
@rank := IF(@prev = point, @rank, @seq) AS Rank,
@prev := point as prev, # I forgot this
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;
Thank you
Tom
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
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
Re: RANK() emulator?
November 19, 2009 10:45AM