Friday, 14 March 2014

How to Delete duplicate rows in Oracle Database

Purpose: To delete duplicate rows from Table. There are many ways to do this, but i can remember this right now..

delete from table_name A where A.rowid >
   (select min(B.rowid) from table_name B where A.col = B.col);

No comments:

Post a Comment