README.md

Description

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.

Solution

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

Note

If you have a better solution, you can star and fork Leetcode-database-problem then create a pull request.