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
What is a db2 table?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is load replace in db2?
Give the name of some fields form sqlca.
What is runstats and reorg in db2?
What is universal database?
Explain the contents that are a part of dclgen.
How do I import a csv file into db2?
How do I copy a table in db2?
what is utility for parm lib
What is the meaning concurrency in the db2 database?
How can the duplicate values be eliminated from db2 select?
What is plan in cobol db2?
What is db2 plan table?
Mention the downsides of page level lock.