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

What's The Percentage Free Space ?

992


Give the name of some fields form sqlca.

851


What is temporal table in db2?

830


What is a trigger in the db2 database?

839


Is ibm db2 open source?

857


How connect db2 database to datastage?

1014


What is the difference between spufi and qmf?

846


How do I create a view in db2?

816


What is db2 and what is the use of db2 optimizer?

858


What is a db2 collection?

820


How to execute stored procedure in db2 command editor?

778


What is the use of dclgen in db2?

825


What is the role of union all and union

889


What is nvl in db2?

845


Explain about cursor stability?

819