> For the complete documentation index, see [llms.txt](https://anand-aryan.gitbook.io/leetcode/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://anand-aryan.gitbook.io/leetcode/182.-duplicate-emails.md).

# 182. Duplicate Emails

Duplicate Emails

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.

## Solution <a href="#solution" id="solution"></a>

```java
# Write your MySQL query statement below
select distinct p1.Email
from Person p1, Person p2
where p1.Id <> p2.Id and p1.Email = p2.Email
```