How will you delete duplicate records from a table?
- 7 Answers
- 23550 Views
- Google, I also Faced
- E-Mail Answers
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
Give a brief description of db2 isolation levels?
What are host variables in db2?
What is dbrm library?
What is the use of with ur in db2?
Explain about cursor stability?
What is cobol db2?
What is db2?
How to execute stored procedures?
What is the physical storage length of time data type?
How can you do the explain of a dynamic sql statement?
What is an instance database?
What is the clustering index in the db2 database?
How do I add a column in db2?
How do I import a csv file into db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
