List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 13 2002 7:49pm
Subject:Re: Any way to make a "top ten" query?
View as plain text  
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
>
>
>


Thread
Any way to make a "top ten" query?Yrjö Mäenpää13 Jun
  • RE: Any way to make a "top ten" query?Peter Romianowski13 Jun
    • RE: Any way to make a "top ten" query?Keith C. Ivey13 Jun
      • RE: Any way to make a "top ten" query?Peter Romianowski13 Jun
  • Re: Any way to make a 'top ten' query?Nick Stuart13 Jun
  • RE: Any way to make a "top ten" query?Jay Blanchard13 Jun
  • Re: Any way to make a "top ten" query?John Klein13 Jun
  • Re: Any way to make a "top ten" query?Gerald Clark13 Jun
  • Re: Any way to make a "top ten" query?Jason13 Jun