title: MSSQL Query to delete duplicate rows from a TABLE leaving distinct rows in table
body: <p>I need to <strong>delete all duplicate rows except the first occurrence</strong> of similar rows from a Table <code>Log</code> having the same <code>customer_id</code> and <code>deactivation_date</code>. How do I achieve that with minimum number of sql statements. </p>
  
  <p>I Am using MS SQL Server 2008 express edition.</p>