182. Duplicate Emails
- Total Accepted: 27110
- Total Submissions: 73222
- Difficulty: Easy
- Contributors: Admin
Write a SQL query to find all duplicate emails in a table named Person.
+----+---------+ | Id | Email | +----+---------+ | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | +----+---------+
For example, your query should return the following for the above table:
+---------+ | Email | +---------+ | a@b.com | +---------+
Note: All emails are in lowercase.
Idea
# Write your MySQL query statement below select distinct p1.Email as Email from Person p1, Person p2 where p1.Email = p2.Email and p1.Id != p2.Id
There are many other ways: https://discuss.leetcode.com/topic/7485/i-have-this-simple-approach-anybody-has-some-other-way