Help with SQL. Maximum values of a table.?

Question

I need help writing an SQL statement that finds the HIGHEST 10 values of a table. Not top where it just gives me the first 10 values in a table but the HIGHEST.

Answer 1

SELECT * FROM table ORDER BY field DESC LIMIT 10

Answer 2

You can use order by clause to get the highest value you want.

http://www.sql-statements.com/sql-select-top.html

Answer 3

Visage has it right...if LIMIT doesn't work with your DBMS, try TOP instead - one of the two should work with most of the DBMS out today (if not, there's a workaround, but it's messy).