From: Wm Mussatto
Date: September 5 2007 4:02pm
Subject: RE: Simple questio SQL
List-Archive: http://lists.mysql.com/mysql/208938
Message-Id: <2320.192.168.0.243.1189008146.squirrel@secure2.csz.com>
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit

On Wed, September 5, 2007 7:17, Jay Blanchard said:
> [snip]
> I have a Table and want to know the most visited products.
> Products
>
> -          Id
>
> -          Name
>
> -          Visited
> [/snip]
>
> SELECT Id, Name, count(Visited) AS Total_Visits FROM product GROUP
> BY(Id)
  order by Total_Visits desc limit 5
That should get you the top 5 from most to least visited.

------
William R. Mussatto
Systems Engineer
http://www.csz.com
909-920-9154