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)));/