182. Duplicate Emails

JIAKAOBO

LeetCode

感谢赞助!

• ㊗️
• 大家
• offer
• 多多！

Problem

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

+----+---------+
| Id | Email   |
+----+---------+
| 1  | [email protected] |
| 2  | [email protected] |
| 3  | [email protected] |
+----+---------+

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

+---------+
| Email   |
+---------+
| [email protected] |
+---------+

Code

# Write your MySQL query statement below
SELECT Email
FROM (
    SELECT COUNT(*) AS num, Email
    FROM Person
    GROUP BY Email
) AS temp
WHERE temp.num >= 2