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
How to check table size in db2 sap?
How would the varchar column remarks defined?
What is the use of db2 optimizer?
What is the syntax for creating a table in the db2 database?
What is meant by union and union all?
what is the role of the cursor in db2?
What kind of database is db2?
What is cursor with hold option in db2?
What is db2 instance?
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 ?
what is db2 restart?
What is the purpose of using commit?
What is the purpose of rollback and commit?
Can there be more than one cursor open for any program?
How does a cursor work?