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 | +---------+
# Write your MySQL query statement below
select Email from (select * from Person group by Email having count(Email)>= 2) a;
总结:运用聚集函数的时候时候一定要注意分组,还有就是where 和 having,where 不能用聚集函数。