42.查找重复的电子邮箱

/*编写一个 SQL 查询,查找 Person 表中所有重复的电子邮箱。*/
SELECT email AS Email
FROM Person
GROUP BY email
HAVING COUNT(email) > 1;

 

posted @ 2022-03-14 08:46  随遇而安==  阅读(19)  评论(0编辑  收藏  举报