delete from tb_table where id not in (select maxid from (select max(id) as maxid from tb_table group by sample_code) b);
tb_table:表名;
id,sample_code:列名
delete from tb_table where id not in (select maxid from (select max(id) as maxid from tb_table group by sample_code) b);
tb_table:表名;
id,sample_code:列名
转载于:https://www.cnblogs.com/zyh-C/p/10491374.html