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