删除表中重复记录最有效的两种方法

******************
最有效的两种方法
******************
delete zhao_2 where rowid in (
select rid from
(select rowid rid,
        row_number() over(partition by updatetime order by feesetcode desc) rn from zhao_2 )
 where rn > 1) ;
 
DELETE FROM zhao_2 E
WHERE E.ROWID > (SELECT MIN(X.ROWID) FROM zhao_2 X WHERE X.FEESETCODE = E.Feesetcode);

******************