力扣——查找重复的电子邮箱(数据库的题

编写一个 SQL 查询,查找 Person 表中所有重复的电子邮箱。

示例:

+----+---------+| Id | Email |+----+---------+| 1 | a@b.com || 2 | c@d.com || 3 | a@b.com |+----+---------+

根据以上输入,你的查询应返回以下结果:

+---------+| Email |+---------+| a@b.com |+---------+

# Write your MySQL query statement belowselect Email from person group by email having count(email)>1;

 

相关文章