Interested to Buy Any Domain ? << Click Here >> for more details...
How will you delete duplicate records from a table?
- 7 Answers
- 24843 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / mehdee
Hi. This is a database design problem, because if you
alowe duplicate rows then you must have at least a column
being like squence number.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is sqlca’s maximum length?
What is check constraint in db2?
what are bind concepts in db2 cobol?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the maximum size of varchar data type in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is dbrm in db2 database?
What is collection in db2 bind?
How to create backup table in db2?
What is clone table?
Explain the contention situations caused by locks?
What is bind and rebind in db2?
What is the use of predicate?
What r the comman abends in db2, jcl and cobol???????
