【数据库领域】You can't specify target table 'Person' for update in FROM clause
delete from Person where id in (select max(id) from person group by Email having count(*)>1); 在练习sql时 报错。
原因delete和select不能同时执行 使用笛卡尔积自关联表 筛选出条件
DELETE p1.*
FROM Person p1,
Person p2
WHERE
p1.Email = p2.Email AND p1.Id > p2.Id
