DELETE FROM TABLE ABC WHERE COLUMN = (SELECT COLUMN FROM TABLE ABC GROU

How will you delete duplicate records from a table?

Question Posted / s

Answer Posted / s

DELETE FROM TABLE ABC
WHERE COLUMN =
(SELECT COLUMN FROM TABLE ABC
GROUP BY COLUMN
HAVING COUNT(*) > 1);

Is This Answer Correct ?

20 Yes

36 No

Please Help Members By Posting Answers For Below Questions

What is access path in db2?

933

Is ibm db2 open source?

1030

What is a plan and package in db2?

1057

Why do we use cursor?

1056

List out the buffer pools in db2

1029

How can we retrieve the total number of records in RPG & CLLE?

593

What is db2 catalog database?

995

Explain about rct.

1036

What is plan in cobol db2?

1074

How connect db2 database to datastage?

1196

What is the difference between using bind () and rebind () methods of naming class?

1345

What is netezza database?

966

Mention the different locking levels that are available in db2.

1092

How to find schema of a table in db2?

970

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

1005