June 16, 2009 at 8:49 pm
Scenario: table called EmailAddresses and the columns ID (int) and EmailAddress (varchar(100))
Query:
SELECT * FROM EMailAddresses WHERE EMailAddress IN (SELECT EMailAddress FROM EMailAddresses GROUP BY EMailAddress HAVING COUNT(*) >2;
June 16, 2009 at 9:59 pm
john (6/16/2009)
Scenario: table called EmailAddresses and the columns ID (int) and EmailAddress (varchar(100))Query:
SELECT * FROM EMailAddresses WHERE EMailAddress IN (SELECT EMailAddress FROM EMailAddresses GROUP BY EMailAddress HAVING COUNT(*) >2;
(SELECT EMailAddress FROM EMailAddresses GROUP BY EMailAddress HAVING COUNT(*) >2)
June 16, 2009 at 10:08 pm
Thank you, so has the first part which you did not use, was that valid in previous versions or?
June 16, 2009 at 10:12 pm
john (6/16/2009)
Thank you, so has the first part which you did not use, was that valid in previous versions or?
No no, i just wrote the part with error in the inner query..
The inner query didnt have a closing braces ')' which i appended in bold (doesnt look like bold tho)
u've to run full query.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply