Results 1 to 2 of 2

Thread: delete duplicate values except one?

  1. 08-06-2003, 09:01 AM #1
    samkud
    samkud is offline Registered User
    Join Date
    Aug 2003
    Posts
    8

    delete duplicate values except one?

    Hi Everybody,

    How to delete the duplicate values from the columns except one. For Eg. if the name of the table is "emp" with only one field "empname" of type varchar. This field has got four values all of which are duplicate. Eg. "samir" "samir" "samir" "samir"

    What I want is to delete 3 records and keep only one value. How do I achieve that?

    Regards,

    Samir.
    Reply With Quote Reply With Quote
  2. 08-06-2003, 09:40 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    There was recent article here, that might help you

    http://www.databasejournal.com/featu...le.php/2235081
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules