08 June, 2013

Removing duplicate rows from a table in oracle

Just write following simple query:

Delete  FROM table_name
WHERE ROWID not in
(SELECT MIN(ROWID)
FROM table_name
group by column1,column2,column3...)


Enjoy...........

No comments:

Post a Comment