Results 1 to 2 of 2

Thread: Remove a duplicate record

  1. #1
    Join Date
    Jan 2014
    Location
    Waukesha, WI
    Posts
    1

    Remove a duplicate record

    I somehow duplicated 2 records in my database. Is there a way to delete the duplicates?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You have to write a query to identify duplicates and delete them. The syntax depends on the database system you are using. Typically you compare columns that should uniquely identify a record and pick one of the duplicate as delete candidate based on some additional criteria such as timestamp.

Posting Permissions

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