| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Alex Arul Lurthu | Date: | September 5 2007 2:20pm |
| Subject: | Re: Simple questio SQL | ||
| View as plain text | |||
select * from Products order by Visited desc limit 10; should give you the top 10 products. On 9/5/07, Tomas Abad <informatica@stripped> wrote: > > HI All, > > > > I have a Table and want to know the most visited products. > > > > Products > > - Id > > - Name > > - Visited > > > > Visited is numeric. > > -- Thanks Alex http://alexlurthu.wordpress.com
| Thread | ||
|---|---|---|
| • Simple questio SQL | Tomas Abad | 5 Sep |
| • Re: Simple questio SQL | Martijn Tonies | 5 Sep |
| • RE: Simple questio SQL | Jay Blanchard | 5 Sep |
| • Re: Simple questio SQL | Alex Arul Lurthu | 5 Sep |
| • RE: Simple questio SQL | Wm Mussatto | 5 Sep |