Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2016
    Posts
    16

    Unanswered: Problems creating a "delete query" to delete duplicate rows/records

    When I create a "delete query" it deletes everything in the table (table is named (Deliveryorderalternative). I need it to delete only the duplicate rows/records (under the AlternativeDesc category) while leaving the 1st original row/record intact. What is the procedure to accomplish this?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Put a where clause to limit the row (s) affected
    But your issue is how do you know which rows are duplicates? And by definition which rows to delete (and keep)
    But even more important why or how are you getting duplicate rows in the first place. Sometimes thats done through table / column / index design, sometimes its manual procedures , usually its both
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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