# Duplicate Emails LeetCode Solution

·1 min

leetcode
SQL

## Table of Contents

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] | +———+

**Note**: All emails are in lowercase.

Link: https://leetcode.com/problems/duplicate-emails/

Solution 1>

## Solution 1 #

select distinct A.Email from Person A, Person B where A.Email = B.Email and A.Id <> B.Id;

Solution 2>

## Solution 2 #

select Email from Person group by Email having count(Email) > 1;