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