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

How to fetch the last row from the table in SQL (db2)?

1596

What is scrollable cursor in db2?

1011

How can the duplicate values be eliminated from db2 select?

1050

What is the difference between nvl and coalesce?

1016

Mention the different locking levels that are available in db2.

1084

Define db2 and its databases?

1015

How to run db2 command in windows?

1148

What is node in db2?

996

Is db2 relational database?

924

What is a db2 table?

969

What is db2?

1133

What do you mean by cursor?

950

How to execute stored procedure in db2 command editor?

998

Define sqlca.

1062

What is copy pending status in db2?

1077