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)