LeetCode 0182 - Duplicate Emails
Contents
Duplicate Emails
Desicription
Write a SQL query to find all duplicate emails in a table named Person
.
1 | +----+---------+ |
For example, your query should return the following for the above table:
1 | +---------+ |
Note: All emails are in lowercase.
Solution
1 | SELECT DISTINCT P1.Email |