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

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

2175

How and when does the db2 enforces the unique key?

1143

What is the meaning concurrency in the db2 database?

1167

What is dbrm in db2 database?

1194

What is alias in db2?

1108

What are foreign keys in db2?

1170

What is a collection in db2?

1093

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2091

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1136

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1151

How to find primary key of a table in db2?

1115

What is null indicator in cobol db2?

1111

How can you find out the # of rows updated after an update statement?

1154

What are the contents of a dclmgen?

1176

How to compare data between two tables in db2?

1138