How to retrieve highest 10 numbers

[nnjgmatt]

Im working on a table were it displays the top 10 users on the site. Their reputation is based on a number so how do I find the 10 highest numbers in a table?

Once I figure out my answer I will post back to help others in the future.

[minimihi]

You would need to order number column from highest to lowest value and select first 10 rows.

For that you should check out ORDER BY optimization and LIMIT optimization for SELECT sentence.

[egami]

SELECT * FROM table ORDER BY column LIMIT 10