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数据库字段去重
最新推荐文章于 2024-07-16 11:54:08 发布
delete from 表名 where rowid in
(select rid from
(select rowid rid,row_number() over(partition by 需要去重的字段 order by rowid) rn from 表名)
where rn <> 1 );