[leetcode]Delete Duplicate Emails

来源:互联网 发布:ubuntu恢复出厂 命令 编辑:程序博客网 时间:2024/05/22 15:45

language:mysql

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

use test;create table Person(Id int auto_increment primary key,Email varchar(100));insert into Person(Email) values('john@example.com'),('bob@example.com'),('john@example.com');
0 0