mit

select E_MAI00001, count(*) from
email3 group by E_MAI00001
having count(*) > 1

findest du die doppelten

Robi