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

What is the use of runstats in db2?

1109

What is the role of schema in the db2 database?

1273

What happens in bind step in a db2 program?

970

What is the role of union all and union

1127

What is the clustering index in the db2 database?

1001

What is db2 catalog database?

1041

What is cursor with hold option in db2?

1072

What is db2?

1182

What is the use of db2?

1055

What are db2 objects?

1045

What is buffer pool and list some of them?

1028

How do you find the maximum value in a column in db2?

1104

How to run db2 command in windows?

1193

What types of tables are there in the db2 database?

1056

What is null value in db2?

1024