Duplicate Emails.md

Hints

Use GROUP BY on Email to see how many of each Id there exists for each email.

Use the HAVING clause since the WHERE clause doesn't support aggregate functions

MySQL Solution

SELECT Email FROM Person
GROUP BY Email
HAVING Count(Email) > 1

Links

• github.com/RodneyShag