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 a bind in db2?

790

How do I create a view in db2?

816

What is a db2 table?

795

What is a buffer in memory?

829

Where can you declare a cursor in a cobol-db2 program?

804

If I have a view which is a join of two or more tables, can this view be updateable?

936

Explain how can you do the explain of a dynamic sql statement?

885

What are db2 objects?

857

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

941

What is the role of data manager in the db2 database?

883

What is the role of union all and union

891

How to rename a table in DB2 ?

846

What is view db2?

874

What is db2 optimizer?

1018

What is the syntax for seeing the columns and data types of a table in the db2 database?

851