Thread: Getting Counts
View Single Post
  #2 (permalink)  
Old October 27th, 2004, 03:45 PM
shahchi1 shahchi1 is offline
Friend of Wrox
 
Join Date: Jan 2004
Location: , , USA.
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I apologize if I have not understand you question. Is this you are looking for..?

SELECT ID,Name,Count(Name) As Total
FROM Table
GROUP BY ID,Name
Reply With Quote