-- 중복된 자료 찾기
select jojik_cd,haengjungdong_cd,count(*)
  from ihjutong00tt  
group by jojik_cd,haengjungdong_cd
  having count(*) > 1;



-- 중복된 자료  모두 삭제
delete from ihjutong00tt a
where rowid > (select min(rowid)
               from ihjutong00tt
                           where jojik_cd = a.jojik_cd
                   and haengjungdong_cd = a.haengjungdong_cd);