title: SQL Server 2008: delete duplicate rows
body: <p>I have duplicate rows in my table, how can I delete them based on a single column's value?</p>
  
  <p>Eg</p>
  
  <pre><code>uniqueid, col2, col3 ...
  1, john, simpson
  2, sally, roberts
  1, johnny, simpson
  
  delete any duplicate uniqueIds
  to get 
  
  1, John, Simpson
  2, Sally, Roberts
  </code></pre>