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;