No,, I dumped the table and put it on a different server and tried it there.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 6:37 PM
Subject: Re: count function
Thanks but no change.
--=C
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 5:41 PM
Subject: Re: count function issue
> At 17:26 -0500 9/1
more than 3 instances.
--=C
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 5:06 PM
Subject: Re: count function issue
> At 16:50 -0500 9/18/02, Mc
Doing queries to determine the number of times search terms are used on a
web site.
Here is a sample sql query.
SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING
count(*)>1 ORDER BY count DESC
But the results seem to be inaccurate, by no more that 3.
Anyone run into anything