delete from TABLE
where rowid in
(select rowid from
(select rowid,row_number() over(partition by financode,orgcode,areacode,impawncode,flag
order by financode,orgcode,areacode,impawncode,flag) rn
from TABLE)
where rn>1)
用rowid应该会快吧,就是不知道如果重复数据非常多的话用“in”是不是会降低效率,try it!