查询重复的数据

select * from T_FAYUAN_SXZXRMD a where (a.id) in (select id from T_FAYUAN_SXZXRMD group by id having count(*) > 1)

删除重复的数据

delete from t_CREDITNODE a

where (a.Id) in (select Id from t_CREDITNODE group by Id having count(*) > 1) and rowid not in (select select * from T_FAYUAN_SXZXRMD a where (a.id) in (select id from T_FAYUAN_SXZXRMD group by id having count(*) > 1)min(rowid) from t_CREDITNODE group by Id having count(*) > 1) 原文链接：https://www.f2er.com/oracle/209778.html