如果几条记录没有值不同的字段的话,我还没有想到删除的办法(除了手工删除),如果有一些字段不同的话,还是有办法的。 假设diff为含有不同值的字段,而f1,f2,f3,表示含有相同值的字段且是你要删除的纪录的条件。则 delete from tablename where diff not in (select min(diff) from tablename group by f1,f2,f3,diff)
错了,应该是 delete from tablename where diff not in (select min(diff) from tablename group by f1,f2,f3)
假设diff为含有不同值的字段,而f1,f2,f3,表示含有相同值的字段且是你要删除的纪录的条件。则
delete from tablename where diff not in (select min(diff) from tablename group by f1,f2,f3,diff)