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

Показать описание
# [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
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