Oracle中删除重复的经典方案

DELETE FROM Personnel

WHERE ROWID < (SELECT MAX(P1.ROWID)

            FROM   Personnel AS P1

            WHERE P1.dup_id = Personnel.dup_id

            AND P1.name = Personel1.name

            AND ... );

转载于:https://www.cnblogs.com/zjfdlut/p/3379293.html