Leetcode 196. 删除重复的电子邮箱

题目

Leetcode 196. 删除重复的电子邮箱

代码（7.27 首刷看解析）

官方解法
会产生笛卡尔积

# Write your MySQL query statement below
delete p1 from person p1, person p2 where p1.email=p2.email and p1.id > p2.id;

先根据email分组，找到最小的id，然后删掉不在这个id表里面的

# Write your MySQL query statement below
delete from person where id not in (
  select id from (
    select min(id) id from person group by email
  ) t
);