-----Original Message-----
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 9:18 AM
To: CF-Talk
Subject: OT: Another SQL Question...
I know I'm a PITA...but a have another SQL question.
Take the following query:
SELECT RefKeywords, SUM(RefCount) AS TRefCount
FROM Referer
GROUP BY RefKeywords
ORDER BY SUM(RefCount) DESC
How would I write the same query with a WHERE clause
that had a 'SUM(RefCount) > 5' ??? I get an error with
aggregates in a where clause.
Thanks, Che
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
