Duplicate Emails

Duplicate Emails

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

Example

±—±--------+
| Id | Email |
±—±--------+
| 1 | a@b.com |
| 2 | c@d.com |
| 3 | a@b.com |
±—±--------+
return
±--------+
| Email |
±--------+
| a@b.com |
±--------+

**Solution

@才发现leetcode有SQL语句题…
# Write your MySQL query staSELECT Email
SELECT Email  
  FROM Person
 GROUP BY Email
HAVING COUNT(*) > 1;