Re: Removing Duplicates

From: "John Herbster" <herb-sci1_AT_sbcglobal.net>
Date: Wed, 29 Mar 2006 20:01:11 -0600

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote

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 ... contents ... of original table and insert ...
from ... TempTable

Of course! Thx Brian. Rgds, JohnH
.

References:
- Removing Duplicates
  - From: Jeff Howard
- Re: Removing Duplicates
  - From: Brian Bushay TeamB

Prev by Date: Re: Removing Duplicates
Next by Date: Re: Error message during a delete operation
Previous by thread: Re: Removing Duplicates
Next by thread: Re: Removing Duplicates
Index(es):
- Date
- Thread

Relevant Pages

Re: Using StringList for CSV file
... internationalization issues with commas, stops, semicolons, ... and quotes. ... Rgds, JohnH ...
(borland.public.delphi.non-technical)
Re: WARNING: Duplicate resource(s)
... Rgds, JohnH ... John, ... as normally clicking on a compiler message ...
(borland.public.delphi.ide)
Re: Latest John Herbster Rounding Routines
... Is something wrong with the clock on ... Rgds, JohnH ... Prev by Date: ...
(borland.public.delphi.language.basm)
Re: How to log on to 24 hours of Dexter?
... >> Seems to allow anything not already being used in the chatroom. ... > Rgds, JohnH ... Prev by Date: ...
(borland.public.delphi.non-technical)
Re: SQL and Scientific Notation
... the output data should *exactly* reflect the input data. ... Rgds, JohnH ...
(borland.public.delphi.database.ado)