List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:September 5 2007 2:17pm
Subject:RE: Simple questio SQL
View as plain text  
I have a Table and want to know the most visited products.

-          Id

-          Name

-          Visited

SELECT Id, Name, count(Visited) AS Total_Visits FROM product GROUP
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