'DML' Tag
-
Oracle: How to delete Duplicate rows from a table
April 16, 2009There are many ways to delete duplicate rows from a table, here is one of simple way In the sub query we Select a unique rowid from all the rowid’s ,It can be using any one of MAX, MIN functions and the group by clause should include all the UNIQUE columns we desire. If we [...]