Languages SQL Transactions  

Delete duplicates in a table (cleanly and easily, using ROWID)
download download  
important code information
author:
 Andy Archer
minimum requirements:
Delete duplicates in a table (cleanly and easily, using ROWID) description

This simple SQL statement deletes duplicate rows in each set, using the pseudocolumn ROWID (row address), preserving the first inserted row of each duplicate set.


File List:
@PSC_ReadMe_884_5.txt1Kb
delete_duplicates_2.sql2Kb
Similar code
Delete duplicates in a table (using a FOR UPDATE cursor and PL/SQL control) (Popularity: ) : This PL/SQL block deletes duplicate rows in a table, using a FOR UPDATE cursor and program control. Clear, concise comments ...
User reviews

Write a review:
1 2 3 4 5 6 7 8 9 10
1=poor 10=excellent
Write review*
Your name*
Email*
  (Comments are moderated, and will not appear on this site until the editor has approved them)
 
Rate me
supported os
stats
downloads 42
version
size in Kb 1
popularity   352/5827733
user rating 0/10
ad


New Code
Popular Code