编写SQL查询以在名为Person表中查找所有重复的电子邮件。
输出:a@b.com
用group by 分组然后having 查找count(email)大于1的邮箱
select email from person
group by email
having count(email)>1
编写SQL查询以在名为Person表中查找所有重复的电子邮件。
输出:a@b.com
用group by 分组然后having 查找count(email)大于1的邮箱
select email from person
group by email
having count(email)>1