Best way to get result position in mysql query?
Posted: Mon Jul 16, 2007 2:41 pm
I have a table, users, that contains information about the user and also user points (I'm running a scoring system).
I'm wondering which way is the best to get a users ranking according to the points.
That is, I want to display the users ranking generated by the following query "SELECT * FROM users GROUP BY Points ORDER BY Points DESC"
Thanks.
I'm wondering which way is the best to get a users ranking according to the points.
That is, I want to display the users ranking generated by the following query "SELECT * FROM users GROUP BY Points ORDER BY Points DESC"
Thanks.