to delete the duplicate record from Oracle table plz provide command
to delete the duplicate record from table plz provide command
Software/Hardware used:
s/w
Software/Hardware used:
s/w
ASKED:
February 22, 2010 8:22 AM
UPDATED:
February 22, 2010 3:35 PM
Answer Wiki:
You could use something like this:
DELETE
FROM your_table t
WHERE EXISTS
(SELECT 1
FROM your_table
WHERE id = t.id
AND rowid < t.rowid);
In this example 'id' would be the field used to identify duplicates.
I used rowid to decide what record to keep in the table, but you could use any other field(s) as needed.
-CarlosDL
-----------------------
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
