Tuesday, 16 April 2013

Oracle: Sql query to delete duplicate rows from a table


For example we have a table "emp" . Duplicate entries of rows can be deleted  from this table as follows: 

delete from emp where rowid not in ( select max(rowid) from emp group by empno)

Now there wont be  duplicate entry for any row in emp

No comments:

Post a Comment