Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Deleting Duplicates

Discussion in 'Information Technology' started by Larry G., Jul 28, 2006.

  1. Larry G.

    Larry G.
    Expand Collapse
    Guest

    I have a HUGE database that I have to weed all the duplicates out of before I
    can upload it into an online database.

    I have run a Find Duplicates Query, and it returned over 42,000 results. Is
    there a quicka nd easy way ot delete these duplicates?
    --
    Never give up, the answer IS out there, it just takes a while to find it
    sometimes!
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Is Mahesh Bhatt considering deleting Meera's controversial kissing ... Breaking News Mar 4, 2005

  3. Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    It can be done with a DELETE query such as the following where you want to
    retain one instance of each LastName, and MyID is a uniquely valued field
    such as an autonumber:

    DELETE *
    FROM
    MyTable AS T1
    WHERE MyID >
    (SELECT MIN(MyID)
    FROM MyTable As T2
    WHERE T2.LastName = T1.LastName);

    Or a simple way is to copy the structure of the table to a new empty table,
    and create a unique index on the field or fields in the table which determine
    what rows are duplicated. If you then append the rows from the original
    table to the new empty table with an append query only one instance of each
    duplicated row will be appended due to the index violations. You can then
    delete the original table (having backed it up of course!) and rename the new
    one.

    Ken Sheridan
    Stafford, England

    "Larry G." wrote:

    > I have a HUGE database that I have to weed all the duplicates out of before I
    > can upload it into an online database.
    >
    > I have run a Find Duplicates Query, and it returned over 42,000 results. Is
    > there a quicka nd easy way ot delete these duplicates?
    > --
    > Never give up, the answer IS out there, it just takes a while to find it
    > sometimes!
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page