[Oracle]중복행제거 쿼리문

[Oracle]중복행제거 쿼리문

DELETE FROM table1 a
WHERE ROWID < (SELECT MAX(ROWID)
FROM table1 b
WHERE a.col1 = b.col1
AND a.col2 = b.col2
AND a.col3 = b.col3
AND a.col4 = b.col4)


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