查询重复的数据
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)