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 db2 bind process?

1179

What is dbrm library?

999

What is precompiler in db2?

958

How to restart a DB2 program?

1827

What is buffer pool?

1028

What is db2 optimizer?

1178

What do you mean by cursor?

942

What is a buffer in memory?

1006

How do you find the maximum value in a column in db2?

1052

define clustering index.

978

Comment whether the cursor is closed during commit or not.

1040

List out the three types of page locks that can be held.

1091

What do you mean by storage group (stogroup)?

984

what is the role of the cursor in db2?

1000

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

1044