View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 07:00 AM
Jay Blanchard
 
Posts: n/a
Default RE: Simple questio SQL

[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)
Reply With Quote