title: Delete duplicate records without using ROW_NUMBER() function
body: <p>I want to delete duplicate records without using ROW_NUMBER() function (SQL Server)</p>
  
  <p>Example: Table with the following data:</p>
  
  <pre><code>name     salary
  -----------------
  Husain   20000.00
  Husain   20000.00
  Husain   20000.00
  Munavvar 50000.00
  Munavvar 50000.00
  </code></pre>
  
  <p>After deleting the duplicate records
  table should contains data like this: </p>
  
  <pre><code>name     salary
  -----------------
  Husain   20000.00
  Munavvar 50000.00
  </code></pre>