查询重复的数据
select * from t_qyxyjcxxb a where (a.fid) in (select fid from t_qyxyjcxxb group by fid having count(*) > 1)
删除重复的数据
delete from t_qyxyjcxxb where id in (select fid from t_qyxyjcxxb group by fid having count(fid) > 1) and rowid not in (select min(rowid) from t_qyxyjcxxb group by fid having count(fid )>1)