- 查找重复的电子邮箱
编写一个 SQL 查询,查找 Person 表中所有重复的电子邮箱。
示例:
+----+---------+
| Id | Email |
+----+---------+
| 1 | a@b.com |
| 2 | c@d.com |
| 3 | a@b.com |
+----+---------+
根据以上输入,你的查询应返回以下结果:
+---------+
| Email |
+---------+
| a@b.com |
+---------+
说明:所有电子邮箱都是小写字母。
思考线==========================
=====================================
=============================
=================================
====================
本人解题方法:通过group by 分组,然后子查询出现次数大于1的email
select p.Email as Email
from (
select Email, count(Email)as cou
from Person
Group by Email
) p where p.cou > 1
leetcode平台其他解题方法:
使用 GROUP BY 和 HAVING 条件
select Email
from Person
group by Email
having count(Email) > 1;
优先顺序:where>group by>having>order by