182. Duplicate Emails

Description

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]

Constraints

Approach

Links

• GeeksforGeeks

• Leetcode

• ProgramCreek

• YouTube

Examples

Example 1

Input:

{"headers": {"Person": ["Id", "Email"]}, "rows": {"Person": [[1, "[e-mail]"], [2, "[e-mail]"], [3, "[e-mail]"]]}}

Output:

{"headers": ["Email"], "values": [["[e-mail]"]]}

Solutions

Solution 1

# MySQL query statement

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

Follow up