473,388 Members | 1,298 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

Removing Duplicate Data Problem..!

En
Any ideas what to do for the best?

I have a table that records some transaction data. Each entry in the table
has an auto gen primary key / ID.

Somewhere along the way there are 1000's of duplicate transactions been
entered, however they are unique because they have different primary key /
ID.

Does anyone know the best way to remove the duplicates from the table but
leaving one copy of the transaction in the table???

I tried a simple delete find duplicate query that found all the duplicates
including the original transaction. I cant afford to delete the original
transaction though.

Any suggestions welcome.

Ian
Nov 12 '05 #1
2 1464
Take a look at this article ...

http://www.databasejournal.com/featu...le.php/3077791
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"En" <ia*@ihankinson.freeserve.co.uk> wrote ...
Any ideas what to do for the best?

I have a table that records some transaction data. Each entry in the table
has an auto gen primary key / ID.

Somewhere along the way there are 1000's of duplicate transactions been
entered, however they are unique because they have different primary key /
ID.

Does anyone know the best way to remove the duplicates from the table but
leaving one copy of the transaction in the table???

I tried a simple delete find duplicate query that found all the duplicates
including the original transaction. I cant afford to delete the original
transaction though.

Any suggestions welcome.

Ian

Nov 12 '05 #2
En
That looks excellent, thankyou.

Ian
"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in message
news:bt************@ID-82595.news.uni-berlin.de...
Take a look at this article ...

http://www.databasejournal.com/featu...le.php/3077791
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"En" <ia*@ihankinson.freeserve.co.uk> wrote ...
Any ideas what to do for the best?

I have a table that records some transaction data. Each entry in the table has an auto gen primary key / ID.

Somewhere along the way there are 1000's of duplicate transactions been
entered, however they are unique because they have different primary key / ID.

Does anyone know the best way to remove the duplicates from the table but leaving one copy of the transaction in the table???

I tried a simple delete find duplicate query that found all the duplicates including the original transaction. I cant afford to delete the original
transaction though.

Any suggestions welcome.

Ian


Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Rad | last post by:
I have a table . It has a nullable column called AccountNumber, which is of varchar type. The AccountNumber is alpha-numeric. I want to take data from this table and process it for my application....
9
by: vbportal | last post by:
Hi, I would like to add BitArrays to an ArrayList and then remove any duplicates - can someone please help me forward. I seem to have (at leaset ;-) )2 problems/lack of understanding (see test...
4
by: sri2097 | last post by:
Hi all, I'm storing number of dictionary values into a file using the 'cPickle' module and then am retrieving it. The following is the code for it - # Code for storing the values in the file...
6
by: sara | last post by:
I have a procedure to automate bringing several Excel files into our Access tables, on a daily basis. The problem is that if the user has a problem, and tries to run the import again (maybe 3...
10
by: Backwards | last post by:
Hello all, I'll start by explaining what my app does so not to confuss you when i ask my question. ☺ I have a VB.Net 2.0 app that starts a process (process.start ...) and passes a prameter...
1
by: gaikokujinkyofusho | last post by:
Hi, I have been enjoying being able to subscribe to RSS (http://kinja.com/user/thedigestibleaggie) for awhile and have come up with a fairly nice list of feeds but I have run into an annoying...
12
by: joestevens232 | last post by:
Hello Im having problems figuring out how to remove the duplicate entries in an array...Write a program that accepts a sequence of integers (some of which may repeat) as input into an array. Write...
1
by: PerumalSamy | last post by:
Hi I am having table with more 13 lakhs records. I am having duplicate records in it. i need to remove that. I wrote the following query SELECT *
7
by: =?Utf-8?B?Sm9lbCBNZXJr?= | last post by:
I have created a custom class with both value type members and reference type members. I then have another custom class which inherits from a generic list of my first class. This custom listneeds...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.