Oracle 删除根据id 删除重复数据
发布时间：2020-12-12 15:05:38 所属栏目：百科 来源：网络整理
导读：查询重复的数据 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
|
查询重复的数据 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)（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |