leetcode 182. Duplicate Emails

 找出重复的数据。

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

select distinct p1.email from Person p1, Person p2 where p1.email = p2.email and p1.Id != p2.Id