- 查找重复的电子邮箱
思路:我首先想到的是采用自连接的形式,通过查找邮箱相同,需要注意额外的需要排除相同id出现的情况。第二种采用Group By的形式。相比较内连接的形式耗时更少
方法一:内连接的形式
SELECT DISTINCT p1.Email FROM Person p1, Person p2 WHERE p1.Email = p2.Email AND p1.Id != p2.Id
方法二:GROUP BY
SELECT Email FROM
(SELECT Email,count(p.Email) AS NUM from Person p GROUP BY(p.Email) ) N
WHERE N.NUM > 1