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

Can we delete records from view?

968

What is the difference between db2 and oracle?

1134

What are the various data types available in db2?

1094

What is load replace in db2?

997

can all users have the privilage to use the sql statement select * (dml)?

1174

What is universal database?

1073

What is precompiler in db2?

1023

What does runstats do in db2?

1120

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

List out the three types of page locks that can be held.

1149

How to find the number of rows in db2 tables?

1073

Explain about open switch business continuity software?

1137

What is the physical storage length of date data type?

1255

What is db2 instance?

1103

What is a system catalog table in db2?

1187