Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2012

    Unanswered: How to delete duplicate records

    I have a table of records which have duplicate values in a certain column. e.g

    ID      Name       Colour    Rate
    1        John       Black       8
    2        Peter      Black       9
    3        Anne       Blue        8
    4        Polly      Yellow      8
    5        Serah      Green       9
    6        Gary       Yellow      9
    What I would like to do is keep unique Colour values only. So in the above example, there must be only one person who has Black, and only one person who has Yellow. I want the person that is removed to be the one who has the higher rate. So those with 9 will be deleted.

    How can I do this in Access via SQL?
    Last edited by gorgon777; 04-10-12 at 12:08.

Posting Permissions

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