删除表中重复数据的sql

数据初始化

INSERT INTO `del_test` VALUES (1, 'a', 'aa');
INSERT INTO `del_test` VALUES (2, 'a', 'aa');
INSERT INTO `del_test` VALUES (3, 'a', 'bb');
INSERT INTO `del_test` VALUES (4, 'b', 'cc');
INSERT INTO `del_test` VALUES (5, 'b', 'dd');
INSERT INTO `del_test` VALUES (6, 'b', 'dd');
INSERT INTO `del_test` VALUES (7, 'c', 'cc');
INSERT INTO `del_test` VALUES (8, 'c', 'cc');
INSERT INTO `del_test` VALUES (9, 'c', 'cc');
INSERT INTO `del_test` VALUES (10, 'c', 'ff');

 
 

 
 

mysql语句

delete from del_test where id not in (select minId  from (select min(id) minId from del_test group by name,value)b)

 

结果

 

 
ps： 还有就是创建temp表的方法查询插入 。