题目描述:
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.
中文理解:写出sql,查询结果为email是多个记录相同的记录。
解题思路:使用group by having来进行筛选查询即可得到结果。
代码(sql):
select Email
from
(
select Email,count(*) as emailCount
from Person
group by Email
having emailCount>=2
) t1;