delete duplicate records without using common table expression (CTE)
<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>