Re: Removing Duplicates


What is the best way, using SQL, to remove duplicates from an Access
database?

If you have exact duplicate records do a
Select distinct * Into TempTable.
Then delete the contents of the original table and insert the records from the
tempTable
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: deleting a record and doing changes in table
    ... database. ... I suggest you look at this method in Delphi Help ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Having Problem with Parameters in SQL
    ... even if the parameter is null it still should execute, ... What database are you using and have you consulted its ... > Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Compress Access Database?
    ... overwrite and existing database. ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: TADOBetterDataset + Joins
    ... >the current record on display with the database contents ... AdoDataset1.RecordSet.ReSync(adAffectCurrent, adResyncAllValues) ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: insert to database dont appear in TQuery
    ... >I try to call the records from the database and I see nothing. ... >after few actions such change the master record and call again the screen ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)