List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:September 5 2007 2:17pm
Subject:RE: Simple questio SQL
View as plain text  
[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) 
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