Pages

Saturday, July 30, 2011

Delete Duplicate Rows from Oracle Table

DELETE FROM EMPLOYEES WHERE ROWID NOT IN
(SELECT MIN(ROWID)
FROM EMPLOYEES
GROUP BY LAST_NAME ) ;

No comments:

Post a Comment