> That's easy, then.
>
> select email, count(*) from logtable where '2008-...' < logtime and 
> logtime < '2008...' group by email
>
> The "group by" (and possibly "with rollup" and "having" clauses) is what 
> you need to read up on.
>
> If you need one of the IP addresses or other columns to come back, it's 
> harder.


In reality, I need to select based on DK (a company identifier,)the script 
name and the date range but I think that it would be sufficient to return 
with only the email and the count.

Post a reply to this message