此题来自leetcode 182.
编写一个 SQL 查询,查找 Person
表中所有重复的电子邮箱
示例:
Id | |
---|---|
1 | a@b.com |
2 | c@d.com |
3 | a@b.com |
根据以上输入,你的查询应返回以下结果:
a@b.com |
SQL:
1. 注意这里是 Having
select Email from Person group by Email Having count(Email) > 1
2. 使用Group by 和 临时表
SELECT
a.Email
FROM
( SELECT Email, count( Email ) AS cnt FROM Person GROUP BY Email ) a
WHERE
a.cnt > 1