February 6th, 2003, 04:14 PM
|
|
Contributing User
|
|
Join Date: Feb 2001
Posts: 49
Time spent in forums: < 1 sec
Reputation Power: 8
|
|
|
count and destinct?
Hi,
If I have a database table like this:
webpageid entrydate websiteid
3 2/6/03 4:51:49 PM 1
1 2/6/03 4:47:46 PM 1
1 2/6/03 4:45:07 PM 2
1 2/6/03 4:43:45 PM 7
3 2/6/03 4:42:18 PM 7
And I want to query the table to bring back the count of each websiteid. I am looking for a result like this:
websiteid: 1, count 2
websiteid: 2, count 1
websiteid: 7, count 2
Does anyone know the sql that will bring back those results? or is it even possible to do this?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
