Share Your Thinking
Impossible is a word that itself i-m-possible.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment