Thread: HAVING clause
View Single Post
  #1 (permalink)  
Old February 11th, 2004, 11:10 AM
Adam H-W Adam H-W is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , .
Posts: 347
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Adam H-W
Default HAVING clause

I'm getting an error with this statement

select email from competition where Answer =
'Ripple' and email having count(*)> '1' group by email

The error is:

Incorrect syntax near the keyword 'having'.

Also, the email column is not of an int type so I don't know if > 1 will work with it. Basically, I'm trying to find out if there are more than 1 duplicate email entry.

Thanks

Adam
Reply With Quote