top ten query?

[ymds]

i have a grades column. can i use a query that will show only the 10 highest grades?
i'll be very grateful 4 any syntax example!

[maximus]

Select Top 10 Grade from Table1 Order by Grade

Please use the name of your table instead of Table1

[TheShabz]

on a sidenote, this reminds me of a question someone asked me. I think you might enjoy it maximus... and i quote

"how can i write a query that will select the top 10 heights from my heights table and order it by height?"

he basically wrote out the sql in his question.

[maximus]

well thats the irony sometimes my friend so near and yet so far.

[maximus]

Please mark this thread solved.

[maximus]

I see you have not marked this thread solved may I know the reason for it? Please let me know the nature of your problem.