Leetcode no. 182

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.

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