title: How can I remove duplicate rows?
body: <p>I need to remove duplicate rows from a fairly large SQL Server table (i.e. 300,000+ rows).</p>
  <p>The rows, of course, will not be perfect duplicates because of the existence of the <code>RowID</code> identity field.</p>
  <p><strong>MyTable</strong></p>
  <pre><code>RowID int not null identity(1,1) primary key,
  Col1 varchar(20) not null,
  Col2 varchar(2048) not null,
  Col3 tinyint not null
  </code></pre>
  <p>How can I do this?</p>