Db2 Delete Duplicate Rows In Table


Main Menu        Computer Tips        Software Downloads Menu

  Main Question - Posted From Guest:
we have duplicate rows in db2 tables and all the fields are the same, how can we delete the duplicate rows but leave one of the rows in the table. I don't want all of the rows deleted.

Guest Says:
Well thats a good reason to always have a db2 timestamp on the db2 table for the last time the row was updated or row was created. This way you can always control stuff like this. I think I would unload the table and remove them out of a flat file, then reload. Then again you can always write a program to roll through the data and delete db2 rows as needed, but I would surely change the table and add a timestamp.


Add your reply below ...



This site allows you to ask questions and get answers from various posters, you may also answer any posts if you feel like you have input to give. Feel free to ask for help with any new question you wish, but most of the questions here are tech related. You will find many questions and answers related to your Ipod or Ipod Nano, Itunes, audio and video converting, spyware or adware cleanup, pc or other computer questions, and even mainframe questions. Although these are the tech questions most often asked, you will find help on almost any computer or software related subject. Feel free to go to the main menu and review the posts already present, or feel free to ask your own question. (Some questions will be closed once the moderator feels they are sufficiently answered and that no other input is needed).

Your Name:

Your Reply:

Type in verification code:


Main Menu

Shareware and Freeware Database

Tasks and Spyware Database

Various Computer Help Topics