delete from emails where email_id in(select email_id from emails group by email_id having
    count(*) >1)

Delete from email_table where ID NOT IN (SELECT DISCTINCT(email) FROM email_table)