题目11:MySQL---------Duplicate Emails

来源:转载

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] |+---------+

# Write your MySQL query statement belowSELECT Email from PersonGroup By EmailHaving Count(*) > 1;








分享给朋友:
您可能感兴趣的文章:
随机阅读: