Oracle 根据rowid删除重复数据

delete from tbndfuture
where rowid not in
(
select max(rowid) from tbndfuture group by i_code having count(*)>1
union
select max(rowid) from tbndfuture group by i_code having count(*)=1
)

 

posted @ 2021-07-22 14:43  大龙挂了,公主在哪  阅读(317)  评论(0)    收藏  举报