title: Delete duplicate id and Value ROW using SQL Server 2008 R2
body: <p>In SQL Server 2008 R2 I added two duplicate ID and record in my table. When I try to delete one of the last two records I receive the following error.</p>
  
  <blockquote>
    <p><em>The row values updated or deleted either do not make the row unique or they alter multiple rows.</em></p>
  </blockquote>
  
  <p>The data is:</p>
  
  <pre><code>7   ABC         6
  7   ABC         6
  7   ABC         6
  8   XYZ         1
  8   XYZ         1
  8   XYZ         4
  7   ABC         6
  7   ABC         6
  </code></pre>
  
  <p>I need to delete last two records:</p>
  
  <pre><code>7   ABC         6
  7   ABC         6
  </code></pre>
  
  <p>I have been trying to delete last 2 record using the feature "Edit the Top 200 rows" to delete this duplicate id but get the error above.</p>
  
  <p>Any help is appreciated. Thanks in advance:)</p>