有没有好的方法来删除重复的记录,相同的只保留一条即可?.
用delete from table_name where rowid not in
(select min(rowid) from table_name
group by item(1),item(2).....item(n));
用delete from table_name where rowid not in
(select min(rowid) from table_name
group by item(1),item(2).....item(n));