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
What's The Percentage Free Space ?
Give the name of some fields form sqlca.
What is temporal table in db2?
What is a trigger in the db2 database?
Is ibm db2 open source?
How connect db2 database to datastage?
What is the difference between spufi and qmf?
How do I create a view in db2?
What is db2 and what is the use of db2 optimizer?
What is a db2 collection?
How to execute stored procedure in db2 command editor?
What is the use of dclgen in db2?
What is the role of union all and union
What is nvl in db2?
Explain about cursor stability?