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 are bind concepts in db2 cobol?

1093

What parameters are used to control the free space in DB2?

1056

What is the physical storage length of date data type?

1254

What is a db2 schema?

1233

Before you give the explain statement, what are the prerogatives?

1040

Explain what are the various isolation levels possible?

1044

What is a plan and package in db2?

1104

What type of database is db2?

971

What is buffer pool and list some of them?

1028

What are the various data types available in db2?

1094

What are the benefits of using the db2 database?

1229

What is reorg?

1161

Is it possible using max on a char column?

1139

What is schema in db2?

1022

Can we delete records from view?

967