How do i delete duplicate values from a table by reatining its occurance once
<p>There is an EMPLOYEE Table with following data</p>

<pre><code>NAME SALARY
A     100
A     100
B     200
C     300
C     300
D     400 
</code></pre>

<p>please provide me with the quert to delete the duplicates by retaining the occurance once i.e the table has to look like below after performing delete operation</p>

<pre><code>NAME SALARY
A     100
B     200
C     300
D     400 
</code></pre>