g a LIMIT here if it's the count you're looking for?
>
>
> ----- Original Message -
> From: "H. Wade Minter" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, October 10, 2001 3:46 PM
> Subject: [GENERAL] Where to count
>
>
I'm running a DB query on a database of firewall log entries (right now
around 700k rows). What I want to do is pull out some common entries, as
well as the number of times that they occur in the table.
Right now, I'm doing a query like:
select source,destination,service,count(*) FROM logs WHER
