Hosting Provided By

Re: Simple questio SQL

From: Alex Arul Lurthu <alex.lurthu(at)gmail.com>
Date: Wed Sep 05 2007 - 10:20:26 EDT

select * from Products order by Visited desc limit 10; should give you the top 10 products.

On 9/5/07, Tomas Abad <informatica@vipventa.com> 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

Received on Wed Sep 5 12:07:14 2007

This message: [ Message body ]
Next message: Wm Mussatto: "RE: Simple questio SQL"
Previous message: Rick James: "RE: Error in mysql slave server"
In reply to: Tomas Abad: "Simple questio SQL"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:09:02 EDT