[SOLVED] Top 10 mysql query

[sean14592]

Hello.

 

How do I do a mysql query to return the top 10 results ordered by points.

 

For example my database looks like this:

 

User  |  Points

1      |  10

2      |  45

3      |    0

4      |  10

5      |  45

6      |    0

7      |  10

8      |  45

9      |    0

 

So i basically want a leaderboard showing the top 10 users.

 

Cheers

Sean

[sean14592]

anyone?

 

I thought this would eb an easy fix, but I can't find anything anywhere.

[elflacodepr]

You may use the LIMIT() command which you will tell to DB how many results you want to show: LIMIT(0, 10)

 

and to order from highest rating to lowest use: ORDER BY 'Points' DESC

[sean14592]

ok, nice, which one should I do first, order it then limit?

 

 

sean

[trq]

SELECT user FROM tbl ORDER BY points DESC LIMIT 10;