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 node in db2?

1037

Define sqlca.

1102

What is cursor in dbms?

1053

Explain in brief how does db2 determine what lock-size to use?

1034

Explain the contents that are a part of dclgen.

1087

Can you tell me how can you find out the # of rows updated after an update statement?

1093

What is page size in db2?

970

What is a storage group (stogroup)?

1241

What is host variable?

1044

What is the picture clause of null indicator variable?

1127

What is the physical storage length of the data types date, time, and timestamp?

1082

How can the duplicate values be eliminated from db2 select?

1095

How do I add a column to an existing table in db2?

1024

What is declare cursor?

1108

How and when does the db2 enforces the unique key?

1079