delete from emp where ecode IN ( select ecode from emp group by ecode havin

How will you delete duplicate records from a table?

Question Posted / venkat

Answer Posted / venkat

delete from emp where ecode IN ( select ecode from emp group by ecode having count(*) >1 )

Is This Answer Correct ?

5 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How many types of page locks can be held in db2?

1000

What is ibm db2 client?

890

What os does db2 run on?

936

What is db2 and what is the use of db2 optimizer?

1003

What are host variables in db2?

996

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3101

What r the comman abends in db2, jcl and cobol???????

2215

Define db2 and its databases?

1015

What is db2 plan table?

1003

What are union and union all?

934

How to find the number of rows in db2 tables?

1007

What is the difference between plan and package in db2?

1052

What is the latest version of ibm db2?

1213

Which components manage deadlocks in db2?

1029

What is db2 optimizer?

1190