Duplicate Emails LeetCode Solution

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

+—-+———+ | Id | Email | +—-+———+ | 1 | [email protected] | | 2 | [email protected] | | 3 | [email protected] | +—-+———+

For example, your query should return the following for the above table:

+———+ | Email | +———+ | [email protected] | +———+

Note: All emails are in lowercase.

Link: https://leetcode.com/problems/duplicate-emails/

Solution 1 #

select distinct A.Email from Person A, Person B where A.Email = B.Email and A.Id <> B.Id;

Solution 2 #

select Email from Person group by Email having count(Email) > 1;