title: Delete duplicate records in SQL Server?
body: <p>Consider a column named <code>EmployeeName</code> table <code>Employee</code>. The goal is to delete repeated records, based on the <code>EmployeeName</code> field.</p>
  
  <pre><code>EmployeeName
  ------------
  Anand
  Anand
  Anil
  Dipak
  Anil
  Dipak
  Dipak
  Anil
  </code></pre>
  
  <p>Using one query, I want to delete the records which are repeated.</p>
  
  <p>How can this be done with TSQL in SQL Server?</p>