4. Duplicate Emails

Easy
#Aggregations#GROUP BY#HAVING

Problem Description

Write a SQL query to report all duplicate emails in the **Person** table. Return the result table in any order. ### Example **Person Table:** | id | email | | :--- | :--- | | 1 | [email protected] | | 2 | [email protected] | | 3 | [email protected] | **Expected Output:** | Email | | :--- | | [email protected] |

Database Schema

undefined

Sample SQL Solution

-- Write your SQL query to find duplicate emails
SELECT email AS Email
FROM Person
GROUP BY email
HAVING COUNT(email) > 1;