DELETE FROM FILE WHERE FIELD = ALL(SELECT FIELD FROM FILE GROUP BY FIELD H

How will you delete duplicate records from a table?

Question Posted / king

7 Answers
25332 Views
Google, I also Faced
E-Mail Answers

Answer Posted / king

DELETE FROM FILE WHERE FIELD = ALL(SELECT FIELD FROM FILE
GROUP BY FIELD HAVING COUNT(*) > 1)

OR

DELETE FROM FILE WHERE FIELD = ANY(SELECT FIELD FROM FILE
GROUP BY FIELD HAVING COUNT(*) > 1)

Is This Answer Correct ?

1 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the various isolation levels possible?

1179

Explain dclgen.

1270

What is access path in db2?

1042

List down the types of triggers in the db2 database?

1079

What is check constraint. Explain with example.

1162

What is a db2 collection?

1107

What is package in cobol db2?

1161

How to rename a table in DB2 ?

1145

Comment whether the cursor is closed during commit or not.

1169

Why do we use cursor?

1162

What is db2 bind process?

1290

What is consistency token in db2?

1194

What is cursor stability in db2?

1414

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2438

What is the use of value function?

1205