leetcode 196 删除重复的电子邮箱-526互联

删除重复的电子邮箱

mysql 来说，inner join 是在做笛卡尔积

delete p1 from Person p1
inner join Person p2
on p1.email = p2.email
and p1.Id > p2.Id

delete p1 FROM person p1
LEFT JOIN person p2
ON p1.email = p2.email
AND p1.Id > p2.Id
WHERE p2.id IS NOT NULL

DELETE from Person where id not in 
(
    select * from 
(
    SELECT min(id) from Person group by email
) A
)