[Oracle]중복데이터 찾기 쿼리문

[Oracle]중복데이터 찾기 쿼리문

select COMP_NO, FEE_GUBUN , LEVY_DATE_YEAR, LEVY_DATE
from TB_FEE_BACKUP
group by COMP_NO, FEE_GUBUN , LEVY_DATE_YEAR, LEVY_DATE
having count(*) > 1
ORDER BY COMP_NO

참조사이트 :
http://cafe.daum.net/Lovers10/MYx/3?docid=XklB|MYx|3|20060926105933&q=toad%20export&srchid=CCBXklB|MYx|3|20060926105933