Duplicate Emails
LeetCode: Duplicate Emails
Problem:
Write a SQL query to find all duplicate emails in a table named Person.
- Note:
For example, your query should return the following for the above table:
- Examples:
+----+---------+
| 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] |
+---------+
- Analysis:
SELECT: email
FROM: Person
GROUP BY: email
HAVING: count(email) > 1
- SQL:
# Write your MySQL query statement below
SELECT Email FROM Person GROUP BY Email HAVING (count(*) > 1)