language:mysql
delete from Person where Id not in (select * from (select min(Id) from Person group by Email) t);
附
use test;
create table Person(Id int auto_increment primary key,Email varchar(100));
insert into Person(Email) values('john@example.com'),('bob@example.com'),('john@example.com');