182. Duplicate Emails (E)

182. Duplicate Emails

Add to List

Description Submission Solutions

• Total Accepted: 32668
• Total Submissions: 88770
• Difficulty: Easy
• Contributors: Admin

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.

SELECT Email FROM Person GROUP BY Email HAVING COUNT(Email)>1;