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
25030 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 does reorg do in db2?

1024

What is a collection in db2?

1028

What is declare cursor?

1108

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2055

What is copy pending status in db2?

1117

Why do we bind in db2?

1205

What are the rules for db2 programming?

1081

What is scrollable cursor in db2?

1050

What is the syntax for creating a table in the db2 database?

1098

What do you mean by between and in? Is between inclusive of specified range values?

1088

What is dpf in db2?

1096

Are views updateable?

1144

What is load replace in db2?

990

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1074

List down the data types in the db2 database.

1110