title: How do I delete duplicate rows in SQL Server using the OVER clause?
body: <p>Here are the columns in my table:</p>
  
  <pre><code>Id
  EmployeeId
  IncidentRecordedById
  DateOfIncident
  Comments
  TypeId
  Description
  IsAttenIncident
  </code></pre>
  
  <p>I would like to delete duplicate rows where <code>EmployeeId, DateOfIncident, TypeId</code> and <code>Description</code> are the same - just to clarify - I do want to keep one of them.  I think I should be using the <code>OVER</code> clause with <code>PARTITION</code>, but I am not sure. </p>
  
  <p>Thanks</p>