delete table_name
where rowid not in (
select max(rowid) from table_name group t by t.param,t.param
);
现查找表中按不同字段group后的结果,选取rowid最大的,删除剩余的.
delete table_name
where rowid not in (
select max(rowid) from table_name group t by t.param,t.param
);
现查找表中按不同字段group后的结果,选取rowid最大的,删除剩余的.