title: TSQL Remove duplicated rows on some column only
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/18932/sql-how-can-i-remove-duplicate-rows">SQL - How can I remove duplicate rows?</a>  </p>
  </blockquote>
  
  
  
  <p>Example this is my table:</p>
  
  <p>SiteKey, Name, City</p>
  
  <p>The SiteKey is auto increament, Name is different , but some times 2 Sitekey will have same City. </p>
  
  <p>Example:</p>
  
  <pre><code>1, A , CityA
  2, B,  CityB
  3, C,  CityA
  4, D,  CityF
  </code></pre>
  
  <p>so I need to remove rows 3, and keep rows 1,2,4 only.</p>
  
  <p>its on SQL 2005 and up.</p>
  
  <p>thanks your help.</p>