Re: Oracle rank function and MySQL

[Torsten Altmann]

Hello, Mr. Brawley!

I'm very impressed of the code for the ranking function, but I have to tell, that I didn't understand it yet. I tried several select-views to get the clue, but I didn't. Could you manage to change the code for ranking for something like this:
-- Example table
CREATE TABLE tmp(name CHAR(10), pts1 INT, pts2 INT);
INSERT INTO tmp VALUES
('A',12,20),('B',10,25),('C',15,21),('D',12,21),('E',12,20),('F',13,24);

-- View with Ranking depending on pts1 AND pts2
SELECT t1.name, t1.pts1, t1.pts2, COUNT(t1.pts1) AS Rank
FROM tmp t1
JOIN tmp t2 ...
GROUP BY t1.name, ...
ORDER BY t1.pts1 DESC, t1.pts2 DESC, t1.name DESC;

I think, this would be a great clue!

Thanks in advance