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

Give a brief description of db2 isolation levels?

1133

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1319

How is the value function used?

1202

What is meant by union and union all?

1051

Which component is used to execute the sql statements?

1141

What is db2 purescale?

1050

Define db2 and its databases?

1108

What is difference between isnull and coalesce?

1104

What is universal database?

1117

What is a db2 cursor?

1106

When do you specify the isolation level?

1068

Define data page.

1122

Why do we use cursor?

1160

Where do you specify them?

1362

What do you mean by cursor?

1029