Best way to select top few items

[aaron_karp]

I want to select the ten rows from a table with the highest values. I could just do something like:

SELECT ItemName FROM Table ORDER BY DateAdded DESC LIMIT 10

But I feel like there might be a better way....using MAX() maybe? Any suggestions? Thanks.

[devinemke]

Originally posted by aaron_karp
But I feel like there might be a better way....using MAX() maybe?

no, your first instinct was correct