delete from Person where Id not in (select * from (select Min(Id) from Person Group by Email))
这样写报错:Every derived table must have its own alias
错误原因:
中间表必须指定别名
正确写法
delete from Person where Id not in (select * from (select Min(Id) from Person Group by Email) as e)