从表中删除重复记录，考虑如下所示的表：
create table dupes (id integer,name varchar(10));
insert into dupes values (1,'NOPOLEON');
insert into dupes values (2,'DYNAMITE');
insert into dupes values (3,'DYNAMITE');
insert into dupes values (4,'SHE SELLS');
insert into dupes values (5,'SEA SHELLS');
insert into dupes values (6,'SEA SHELLS');
insert into dupes values (7,'SEA SHELLS');
select * from dupes order by 1;
+------+------------+
| id | name |
+------+------------+
| 1 | NOPOLEON |
| 2 | DYNAMITE |
| 3 | DYNAMITE |
| 4 | SHE SELLS |
| 5 | SEA SHELLS |
| 6 | SEA SHELLS |
| 7 | SEA SHELLS |
+------+------------+
解决方案：
delete from dupes
where id not in
(select minid from
(select min(id) as minid from dupes group by name)
b);
说明： group by后面的name是要删除的重复的那一列。
