How do I create a top 10 list

[Anon]

I am trying to create a list with the top 10 GPAs in it. I know that the max()function in SQL will give me the top GPA, but how do I get the top 10???

Thanks

[brandonschnell]

select * from table order by gpa desc limit 10;

[kparker]

Now, since you don't say which dbms you are using, you may be using one that lacks the LIMIT extension. In that case, just say SELECT ... ORDER BY GPA DESC; and then only read the first 10 rows of the result.