182. Duplicate Emails

Description

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

Id	Email
1	[email protected]
2	[email protected]
3	[email protected]

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

Email
[email protected]

Constraints

Approach

Links

• GeeksforGeeks

• Leetcode

• ProgramCreek

• YouTube

Examples

Example 1

Input:

{"headers": {"Person": ["Id", "Email"]}, "rows": {"Person": [[1, "[email protected]"], [2, "[email protected]"], [3, "[email protected]"]]}}

Output:

{"headers": ["Email"], "values": [["[email protected]"]]}

Solutions

Solution 1

# MySQL query statement

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

Follow up