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 are packages in db2?

1019

How can you count the number of rows from a table tab?

1083

What are the various isolation levels possible?

1114

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1095

How to find the number of rows in a db2 table?

1111

What is the default page size of buffer pools?

1118

What does a deadlock mean in DB2?

1158

Which component is responsible for processing sql statements and selecting access paths?

1119

How do we specify index to include or not during bind process.

2120

What is release/acquire in bind?

1100

Define declaration generator (dclgen).

1106

What are the uses of db2 optimizer?

1288

What is reorg?

1145

What is ibm db2 used for?

1065

What happens in bind step in a db2 program?

964