delete from 表
where rowid in
(select rid from (select rowid rid,row_number()
over(partition by 重复的列名 order by rowid) rn from 表)
where rn <>1 );
Oracle删除重复记录行,留剩一行!
最新推荐文章于 2022-05-17 12:30:42 发布
delete from 表
where rowid in
(select rid from (select rowid rid,row_number()
over(partition by 重复的列名 order by rowid) rn from 表)
where rn <>1 );