oracle删除重复数据保留一条

宁文文

于 2022-04-11 17:03:14 发布

阅读量1.2k

点赞数

文章标签： oracle 数据库

本文链接：https://blog.youkuaiyun.com/ningziwen/article/details/124103661

版权

delete from SECURITY_USER_ROLE
 where (ACCOUNT) in (select ACCOUNT
                       from SECURITY_USER_ROLE
                      group by FIELD_CODE
                     having count(ACCOUNT) > 1)
   and rowid not in (select min(rowid)
                       from SECURITY_USER_ROLE
                      group by ACCOUNT
                     having count(*) > 1)