Write a SQL query to find all duplicate emails in a table named Person.
- +----+---------+
- | Id | Email |
- +----+---------+
- | 1 | a@b.com |
- | 2 | c@d.com |
- | 3 | a@b.com |
- +----+---------+
- For example, your query should return the following for the above table:
- +---------+
- | Email |
- +---------+
- | a@b.com |
- +---------+
Note: All emails are in lowercase.
- Code
- SELECT Email from Person GROUP BY Email HAVING count(Email)> 1
- [LeetCode] 182. Duplicate Emails_Easy tag: SQL
来源: http://www.bubuko.com/infodetail-2732296.html