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 SQLTomas Abad5 Sep
  • Re: Simple questio SQLMartijn Tonies5 Sep
  • RE: Simple questio SQLJay Blanchard5 Sep
  • Re: Simple questio SQLAlex Arul Lurthu5 Sep
  • RE: Simple questio SQLWm Mussatto5 Sep