根据MOBILE查询SY_WXUSER表中的重复数据:
select * from SY_WXUSER
where MOBILE in (select MOBILE from SY_WXUSER group by MOBILE having count (MOBILE) > 1)
根据MOBILE删除SY_WXUSER表中的重复数据:
delete from SY_WXUSER
where MOBILE in (select MOBILE from SY_WXUSER group by MOBILE having count (MOBILE) > 1)
and rowid not in (select min(rowid) from SY_WXUSER group by MOBILE having count(MOBILE)>1)