Hello:
Is it possible to write a SQL query to display only Emails that are more then one of and how many? For example if I had the following emails in my table it would tell me that I have $number of $email but only if there is a double email address?
foo@foo.com foo@foo.com test@test.com foo@foo.com
3|foo@foo.com
I hope that makes sense
SELECT email, count(email) FROM table HAVING count(email) > 1
