本文共 220 字，大约阅读时间需要 1 分钟。

题目描述：

SQL：

delete from Personwhere Id not in(    select * from    (select min(Id) from Person group by Email) t)

注：下面的写法MySQL不支持，但SQLServer支持！

delete from Person where Id not in(select min(Id) from Person group by Email)

转载地址：http://oaivf.baihongyu.com/