_182. Duplicate Emails.md

182. Duplicate Emails

All prompts are owned by LeetCode. To view the prompt, click the title link above.

Back to top

---

First completed : May 22, 2024

Last updated : July 01, 2024

---

Related Topics : Database

Acceptance Rate : 71.9 %

---

Solutions

• e182.sql

SQL

e182.sql

SELECT 
    p.email AS 'Email'
FROM
    Person p
GROUP BY 
    p.email
HAVING count(p.email) > 1;