182. Duplicate Emails

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

+----+---------+| Id | Email   |+----+---------+| 1  | [e-mail] || 2  | [e-mail] || 3  | [e-mail] |+----+---------+

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

+---------+| Email   |+---------+| [e-mail] |+---------+

Note: All emails are in lowercase.

Subscribe to see which companies asked this question.

SQL:

# Write your MySQL query statement belowselect     Emailfrom    Persongroup by    Emailhaving     count(Email) > 1;