• support@answerspoint.com

How can I remove duplicate rows?

1884

What is the best way to remove duplicate rows from a fairly large table (i.e. 300,000 rows)?

The rows of course will not be perfect duplicates because of the existence of the RowID identity field.

MyTable
-----------
RowID int not null identity(1,1) primary key,
Col1 varchar(20) not null,
Col2 varchar(2048) not null,
Col3 tinyint not null

1Answer


0

That is false

  • answered 7 years ago
  • Sunny Solu

Your Answer

    Facebook Share        
       
  • asked 8 years ago
  • viewed 1884 times
  • active 8 years ago

Best Rated Questions