Results 1 to 2 of 2

Thread: how to delete duplicate rows in sql server 2000

  1. #1
    Join Date
    Jan 2006
    Location
    Hyderabad, India
    Posts
    26

    how to delete duplicate rows in sql server 2000

    we are using sql server 2000. we have two rows with same data. we want to delete only one row. how to do it?
    in sql server 2005 with the help of rowid we can do that.we are not able to delete the duplicate row in sql server 2000.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    One way can try is set rowcount = 1 then run delete statement.

Posting Permissions

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