本文介绍了一种使用SQL查询来识别和处理数据库中重复记录的方法。包括如何查询重复的customer_id，筛选重复行的最小ID，以及如何删除这些重复的数据。
select rowid from user where agent_id =‘1000020A46’;
–==========查询重复ID
select customer_id from user group by customer_id having count(customer_id)>1;
select * from user where customer_id =‘C87FC09C6140000125F1187C1540A350’;
–=====筛选重复行的最小ID
select min(rowid) from (select rowid from user where customer_id
in(select customer_id from user group by customer_id having count(customer_id)>1));
–=====删除多行重复数据
/delete from user where rowid in(select min(rowid) from (select rowid from user where customer_id
in(select customer_id from user group by customer_id having count(customer_id)>1)));/
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
