codice:
select *, count(*) as tot
from tabella
group by email
having tot > 1