Requete pour le classement d'une table

Réponse acceptée !
salut reprise de google SELECT U1.name, COUNT(*) AS rank FROM Users AS U1 INNER JOIN Users AS U2 ON U2.score > U1.score OR (U2.score = U1.score AND U2.name <= U1.name) GROUP BY U1.name ORDER BY rank name rank John 1 Jim 2 Joe 3 Jerry 4 If you require equal scores to have the same rank then try this SELECT U1.name, COUNT(DISTINCT U2.score) AS rank FROM Users AS U1 INNER JOIN Users AS U2 ON U2.score >= U1.score GROUP BY U1.name ORDER BY rank name rank John 1 Jim 2 Joe 2 Jerry 3 Or alternatively, with a slightly different numbering SELECT U1.name, COUNT(U2.score) + 1 AS rank FROM Users AS U1 LEFT OUTER JOIN Users AS U2 ON U2.score > U1.score GROUP BY U1.name ORDER BY rank name rank john 1 jim 2 joe 2 jerry 4