title: delete duplicate records without using common table expression (CTE)
body: <p>I know how to delete duplicate records using CTE.</p>
  
  <p>How can we achieve this without using CTE [Interview Question]</p>
  
  <p>Is it possible?</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>