title: sql server 2008 deleting duplicates
body: <p>i have duplicates like this</p>
  
  <pre><code>col1, col2
  1, alex
  1, alex
  2, liza
  2, liza
  3, peter
  3, peter
  </code></pre>
  
  <p>there are only two of each. how do i delete the duplicates?</p>