Eternal Technology
FlipKart
FlipKart Casio Watch
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment