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
24860 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 is page size in db2?

918

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1050

Discuss about db2 bind?

1056

What is reorg?

1088

How do you concatenate the firstname and lastname from emp table to give a complete name?

1030

Define buffer pool.

1005

What is clone table?

1007

Explain in brief how does db2 determine what lock-size to use?

980

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2036

What is the maximum size of varchar data type in db2?

1082

Mention the various locks that are available in db2.

984

What is the maximum size of a char data type in db2?

975

What is explain in db2?

972

List down the data types in the db2 database.

1052

How to view db2 table structure?

972