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 cascading rollback?

863

Define data page.

832

What is a plan and package in db2?

851

What are packages in db2?

794

Can there be more than one cursor open for any program?

917

What is innodb buffer pool?

760

Describe major components of db2?

860

Explain the benefits you can get from mainframe connect?

738

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

1864

what are bind concepts in db2 cobol?

834

How to find the maximum value in a column in the db2 database?

829

What is db2 instance?

814

What is cobol db2?

743

What is load utility in db2?

903

What is check constraint in db2?

824