title: Checking for duplicate data in SQL Server
body: <p>Please don't ask me why but there is a lot of duplicate data where every field is duplicated.</p>
  
  <p>For example</p>
  
  <pre><code>alex, 1
  alex, 1
  liza, 32
  hary, 34
  </code></pre>
  
  <p>I will need to eliminate from this table one of the <code>alex, 1</code> rows</p>
  
  <p>I know this algorithm will be very ineffecient, but it does not matter. I will need to remove duplicate data.</p>
  
  <p>What is the best way to do this? Please keep in mind I do not have 2 fields, I actually have about 10 fields to check on.</p>