182. Duplicate Emails.md

182. Duplicate Emails

Question Link

Solution

# Write your MySQL query statement below
select distinct p1.email Email from Person p1
where email in (
    select p2.email from Person p2 where p1.email=p2.email and p1.id != p2.id
)