[thelist] (SQL) Count Distincts

darren darren at web-bitch.co.uk
Fri Jan 31 18:03:01 CST 2003


On Friday, January 31, 2003 at 15:44, Tab Alleman wrote:

TA> SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp),
TA> DayOfMonth(TimeStamp) FROM RedirectLog WHERE (TimeStamp BETWEEN
TA> '20030130000000' AND '20030131000000') GROUP BY Month(TimeStamp),
TA> DayOfMonth(TimeStamp)

i *think* what you need is:

   select
      clientIP, count(distinct *), ...
   etc....

so you are counting the distinct client ip's.

hth,

darren,




More information about the thelist mailing list