[Oracle] 중복 데이터 제거

SELECT

    ROWID,

    C.*

--DELETE

FROM AATEST C

WHERE C.ROWID IN  

(

    SELECT

        B.ROWID

    FROM

    (

        SELECT

            ROW_NUMBER() OVER(PARTITION BY TITLE ORDER BY REG_TS) RNUM,

            ROWID,

            A.*

        FROM AATEST A

    ) B

    WHERE RNUM = 2

)

;