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;