法一:
select distinct a.Email
from Person a,Person b
where a.Id!=b.Id and a.Email=b.Email;
法二:
select Email
from Person
group by Email
having count(Email)>1;
法一:
select distinct a.Email
from Person a,Person b
where a.Id!=b.Id and a.Email=b.Email;
法二:
select Email
from Person
group by Email
having count(Email)>1;