| 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 SQL | Tomas Abad | 5 Sep |
| • Re: Simple questio SQL | Martijn Tonies | 5 Sep |
| • RE: Simple questio SQL | Jay Blanchard | 5 Sep |
| • Re: Simple questio SQL | Alex Arul Lurthu | 5 Sep |
| • RE: Simple questio SQL | Wm Mussatto | 5 Sep |