LEETCODE数据库:182.DuplicateEmails

发表于 更新于 分类于 Waline： 阅读次数：

题目

Write a SQL query to find all duplicate emails in a table named Person.

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

For example, your query should return the following for the above table:

Email
a@b.com

Note: All emails are in lowercase.

题解

1
2
3
4
5
# Write your MySQL query statement below
SELECT Email
FROM Person
Group by Email
HAVING count(Email)>1;