SQL 删除重复数据
建表
1 drop table if exists stu; 2 create table stu ( 3 id integer, 4 name varchar(10) 5 );
插入数据
1 insert into stu values (1,'Jason'); 2 insert into stu values (2,'Bob'); 3 insert into stu values (3,'Bob'); 4 insert into stu values (4,'Bob'); 5 insert into stu values (5,'Mike'); 6 insert into stu values (6,'Mike'); 7 insert into stu values (7,'Jack'); 8 insert into stu values (8,'Jack');
删除name相同的重复数据
1 delete from stu a 2 where exists ( 3 select 1 from stu b where a.name = b.name and b.id > a.id 4 );
