[thelist] (SQL) Count Distincts

[rudy]

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