查询出反复数据

查询出重复数据

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)