删除表内多余的重复数据
删除表内多余的重复数据
采用以下语句执行效率很高
delete from tbgr_photo where rowid in
(select a.rowid from tbgr_photo a, tbgr_photo b where a.rowid>b.rowid and a.ID0000=b.ID0000);
采用以下语句执行效率很高
delete from tbgr_photo where rowid in
(select a.rowid from tbgr_photo a, tbgr_photo b where a.rowid>b.rowid and a.ID0000=b.ID0000);