Duplicate Emails | Problem 182 | Leetcode SQL Interview Problem with Solution

preview_player
Показать описание
# [182. Duplicate Emails]

Table: `Person`

```
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| id | int |
| email | varchar |
+-------------+---------+
id is the primary key (column with unique values) for this table.
Each row of this table contains an email. The emails will not contain uppercase letters.
```

Write a solution to report all the duplicate emails. Note that it's guaranteed that the emailfield is not NULL.

Return the result table in **any order** .

The result format is in the following example.

**Example 1:**

```
Input:
Person table:
+----+---------+
| id | email |
+----+---------+
+----+---------+
Output:
+---------+
| Email |
+---------+
+---------+
```

Disclaimer: Video is for educational purposes only.

#leetcode #sql #interview
Рекомендации по теме
welcome to shbcf.ru