查询出重复数据

select *  from hlinsuredinfo a where (GrpContNo, insuredname, doctype, docNo) in       (select GrpContNo, insuredname, doctype, docNo          from (select GrpContNo, insuredname, doctype, docNo, count(*) co                  from hlinsuredinfo                 group by GrpContNo, insuredname, doctype, docNo)         where co > 1)   and rowid not in (select min(rowid)                       from hlinsuredinfo                      group by GrpContNo, insuredname, doctype, docNo                     having count(*) > 1)

上述sql语句用于查询重复数据，若需要删除，将select * from 改为delete from 即可