delete from table a where rowid >(select min(rowid) from table b where

How will you delete duplicate records from a table?

Question Posted / tharanath.n

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

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