subject:"\(SQL\) Count Distincts"

RE: (SQL) Count Distincts

2003-02-01 Thread Sherzod Ruzmetov

: : I am trying to get a count of Distinct IP's from my homemade hit-log : database (don't ask). The db is MySQL. I'm trying this: : : SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp), : DayOfMonth(TimeStamp) FROM RedirectLog WHERE (TimeStamp BETWEEN : '2003013

Re: (SQL) Count Distincts

2003-02-01 Thread Benjamin Pflugmann

Hi. On Fri 2003-01-31 at 10:44:58 -0500, [EMAIL PROTECTED] wrote: > I am trying to get a count of Distinct IP's from my homemade hit-log > database (don't ask). The db is MySQL. I'm trying this: > > SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp), > DayOfMonth(TimeStamp) FROM RedirectLog W

(SQL) Count Distincts

2003-01-31 Thread Tab Alleman

I am trying to get a count of Distinct IP's from my homemade hit-log database (don't ask). The db is MySQL. I'm trying this: SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp), DayOfMonth(TimeStamp) FROM RedirectLog WHERE (TimeStamp BETWEEN '2003013000' AND '2003013100') GROUP BY Month