Duplicate Emails Problem & Solution

Write a SQL query to find all duplicate emails in a table named Person.

See the duplicate emails problem on LeetCode.

SQL Solution

SELECT Email
FROM Person
GROUP BY Email
HAVING COUNT(Email) > 1;