How will you delete duplicate records from a table?
- 7 Answers
- 23742 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / naresh.s
in DB2
first we need to know duplicate records in database file
like tmpfilep ,for that
select RRN(A) from tmpfilep A where field='fieldvalue'
here field means any fileld containd tmpfilep and
corresponding value.
once we execute the above query we will get relative record
numbers of each row and remember that numbers
now you can delete records based on these numbers
delete from tmpfilep A where rrn(A) in (234,341,642)
here 234,341,642 are sample record numbers
may be i am correct upto my knowledge.......
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is netezza database?
Why do chiropractors use drop table?
What are the different types of base tables?
What is a page in db2?
What is buffer pool and list some of them?
What is isolation level in db2?
How to compare data between two tables in db2?
What is the advantage in De-normalizing tables in DB2?
What is a db2 cursor?
Explain db2.
How do I import data from excel to db2?
How to view db2 table structure?
What is declare cursor?
What is the maximum length of sqlca?
What is with ur in db2?
