[Scenario]

Quote:

Originally Posted by Calgon Theoretically, this should work: (credits) Код: SELECT COUNT('Email Address') AS NumOccurrences FROM Accounts HAVING ( COUNT(NumOccurrences) >= 1 ) (If that doesn't work, it's because of the two speech marks in the COUNT area, it works fine if you use one word without speech marks.) You can just return the result, 0 if no, higher (or equal) 1 if so. Also, a little tip: It's really not wise to use spaces for column names, it's more problematic. Use camel case.

Wouldn't the second query there be better?

Код:

SELECT email FROM users GROUP BY email HAVING ( COUNT(email) = 1 )

And thanks for the tip, I always wondered about that!