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)
oracle删除重复数据保留一条
最新推荐文章于 2024-05-14 17:15:27 发布