Oracle 删除重复数据

 DELETE FROM tb E
 WHERE E.ROWID > (SELECT MIN(X.ROWID)
                    FROM tb X
                   WHERE X.APR_BSS_ID = E.APR_BSS_ID
                   AND X.ID=E.ID
                   AND X.NAME=E.NAME
                 );