Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    39

    Unanswered: Remove Duplicate Data but Keep One

    I have the following:

    ID FNAME LNAME
    1 John Doe
    1 John Doe
    1 John Doe
    2 Joe Doe
    2 Joe Doe
    2 Joe Doe
    3 John Jones
    4 Foo Foo


    I would like to end up like the following:

    ID FNAME LNAME
    1 John Doe
    2 Joe Doe
    3 John Jones
    4 Foo Foo



    Thanks for any advice
    JE

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    SELECT DISTINCT * INTO someothertable FROM yourTable

    DROP yourTable

    RENAME someothertable TO yourTable
    Thanks,

    Matt

Posting Permissions

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