Re: Any way to make a "top ten" query?

[Gerald Clark]

ORDER BY mountainheight DESC LIMIT10

Yrjö Mäenpää wrote:

>As there is no TOP operator nor nested selects in MySQL, I wonder if there
>still exists some clever way to make"top ten" type of a query , i.e. to
>select ten best selling products or ten highest mountains for example.
>
>thanks
>
>
>