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

来源:互联网 时间:1970-01-01

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;








相关阅读:
Top