代码语言:javascript复制
delete from person
where id not in(
select id from(
select min(id) id from
person
group by email)t
)