Assign A Rank To Each Row Of A Result

• Tweet
• 

        Assign a rank to each row of a result

SELECT (
	SELECT COUNT(id) FROM table t2
	WHERE t2.title <= t1.title 
	) AS rank , t1.*
FROM table t1
ORDER BY t1.title

<a href="http://www.ab-d.fr/">Source: </a><a href="http://www.ab-d.fr/date/2009-09-23/">Comment attribuer un rang aux lignes d'un résultat en MySQL ? ( sql ) </a><a href="http://www.vytafitnesssports.fr/">(vyta)</a>    

Tags:
• MySQL
• SQL