How will you delete duplicate records from a table?

Answer Posted / tharanath.n

delete from table a
where rowid >(select min(rowid) from table b
where a.column = b.column);

Is This Answer Correct ?    13 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to check table size in db2 sap?

788


How would the varchar column remarks defined?

850


What is the use of db2 optimizer?

835


What is the syntax for creating a table in the db2 database?

867


What is meant by union and union all?

785


what is the role of the cursor in db2?

819


What kind of database is db2?

783


What is cursor with hold option in db2?

818


What is db2 instance?

811


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2093


what is db2 restart?

1907


What is the purpose of using commit?

833


What is the purpose of rollback and commit?

811


Can there be more than one cursor open for any program?

915


How does a cursor work?

762