Description:Write a SQL query to find all duplicate emails in a table named Person
.
找出表中重复的Email。
# Write your MySQL query statement below select Email from Person group by Email having count(*)>1;
Description:Write a SQL query to find all duplicate emails in a table named Person
.
找出表中重复的Email。
# Write your MySQL query statement below select Email from Person group by Email having count(*)>1;