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