Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401

    Unanswered: Removing duplicates

    Can somebody help me by telling the best way to remove duplicate rows from a table.

  2. #2
    Join Date
    Oct 2003
    Posts
    706

    Wink

    You can query a table with SELECT DISTINCT to cause duplicate data to be omitted.

    You could query the table in this way into a temporary table, empty the old table and repopulate it from the temporary.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    This depends on the structure of your table and what rows will be deleted and which will be kept. Are the entire rows identical (no unique identifier) ? How many records are in the table ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •