How will you delete duplicate records from a table?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a db2 table?

790


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

825


What is load replace in db2?

774


Give the name of some fields form sqlca.

844


What is runstats and reorg in db2?

1036


What is universal database?

861


Explain the contents that are a part of dclgen.

893


How do I import a csv file into db2?

777


How do I copy a table in db2?

784


what is utility for parm lib

2120


What is the meaning concurrency in the db2 database?

878


How can the duplicate values be eliminated from db2 select?

888


What is plan in cobol db2?

813


What is db2 plan table?

838


Mention the downsides of page level lock.

941