select Email
from
Person
group by Email
having count(1) >=2
-------------------------------------
select distinct t1.Email
from
Person t1
join
Person t2
on t1.Email = t2.Email
and t1.Id != t2.Id
select Email
from
Person
group by Email
having count(1) >=2
-------------------------------------
select distinct t1.Email
from
Person t1
join
Person t2
on t1.Email = t2.Email
and t1.Id != t2.Id