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
25079 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

Before you give the explain statement, what are the prerogatives?

1042

What is coalesce in db2?

1136

What is multi row fetch in db2?

1052

What is consistency token in db2?

1145

What is the reason behind not using select * in embedded sql programs?

1115

What are foreign keys in db2?

1108

What kind of database is db2?

1038

Mention some fields that are a part of sqlca.

1034

What is package in db2 mainframe?

989

How and when does the db2 enforces the unique key?

1084

What is a storage group (stogroup)?

1247

Which component is responsible for db2 startup and shutdown?

1036

What is db2 bind?

1084

How does a cursor work?

993

How to get the ddl of a table in db2?

1131