[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