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;
转载于:https://www.cnblogs.com/wxisme/p/4436615.html