Interested to Buy Any Domain ? << Click Here >> for more details...
How will you delete duplicate records from a table?
- 7 Answers
- 25037 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
Describe major components of db2?
What is buffer pool and list some of them?
What is phantom read in db2?
What is temporal table in db2?
What is the purpose of using commit?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Explain the function done by data manager?
What is null in db2?
What is database alias db2?
What is ibm db2 used for?
What is the difference between spufi and qmf?
How to view db2 table structure?
Can you tell me how can you find out the # of rows updated after an update statement?
What is buffer pool?
What's The Percentage Free Space ?
