title: How to skip rows with same column values in SQL Server?
body: <p>I've a table as below:</p>
  
  <pre><code>ColA    ColB    ColC
  `````  ``````  ``````  
  1       Steve   Rodgers  
  2       Tony    Stark  
  3       Steve   Jobs
  </code></pre>
  
  <p>Resultant table should look like this:    </p>
  
  <pre><code>ColA    ColB    ColC
  `````  ``````  ``````   
  2       Tony    Stark  
  </code></pre>
  
  <p>Rows with same value in <code>ColB</code> should be removed. How can I delete/exclude such rows? </p>