SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: Group by
Threaded View
-
Feb 14, 2005, 14:04 #1
- Join Date
- Feb 2005
- Posts
- 8
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Group by
Hi All,
I need a count of how many times certain field value appears in my table.
Here is my code
Select *, count(*) as counter
Group by keyfield
This gives me an error, thus how can I use group by on only one filed and still select rest of fields?
ThanksThanks
Bookmarks