Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Pakistan, Karachi
    Posts
    22

    Red face Unanswered: Remove Duplicate

    HI All,


    I want to remove duplicate records from my table based on nic number. I try to put primray key constraint. But there are many many duplicates so cannot do it can I have a query to remove duplicates..

    Thnx

    Shani

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Remove Duplicate

    Originally posted by shani
    HI All,


    I want to remove duplicate records from my table based on nic number. I try to put primray key constraint. But there are many many duplicates so cannot do it can I have a query to remove duplicates..

    Thnx

    Shani

    http://www.cleardata.biz/articles/dupes.aspx
    http://www.sqlteam.com/item.asp?ItemID=3331

  3. #3
    Join Date
    Apr 2004
    Location
    Greece
    Posts
    3

    Re: Remove Duplicate

    Originally posted by shani
    HI All,


    I want to remove duplicate records from my table based on nic number. I try to put primray key constraint. But there are many many duplicates so cannot do it can I have a query to remove duplicates..

    Thnx

    Shani

    read this:
    http://www.databasejournal.com/featu...le.php/2235081

Posting Permissions

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