【LeetCode】182. Duplicate Emails

题目要求：Write a SQL query to find all duplicate emails in a table named Person.

解答：比较顺的思路就是用GROUP BY、HAVING ；但是还可以用DISTINCT 联表查询的方法。

1) 

SELECT Email FROM Person
GROUP BY Email 
HAVING COUNT(*) >= 2

2) 摘自http://blog.csdn.net/will130/article/details/51095058 （其实我还不熟悉多个组合过滤条件WHERE）

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