[thelist] (SQL) Count Distincts

rudy r937 at interlog.com
Fri Jan 31 18:23:00 CST 2003


hi tab


    select Month(TimeStamp)
         , DayOfMonth(TimeStamp)
         , count(*)
         , count(distinct ClientIP)
      from RedirectLog
     where TimeStamp BETWEEN '20030130000000'
                         AND '20030131000000'
    group
        by Month(TimeStamp)
         , DayOfMonth(TimeStamp)


tell me if count(*) and count(distinct ClientIP) produce different numbers
for your data


rudy




More information about the thelist mailing list