title: MySQL Delete duplicates in consecutive rows
body: <p>Suppose this table:</p>
  
  <pre><code>ID ColA ColB
  1   7    8
  2   7    9
  3   7    9
  4   5    8
  5   6    9
  6   6    9
  7   5    4
  </code></pre>
  
  <p>The PK is the ID coumn.
  Now, I want to delete all duplicates of <code>ColA</code> and <code>ColB</code> in consecutive rows.</p>
  
  <p>In this example rows 2,3 and 5,6 contain duplicates.
  These shall be removed so that the higher ID is remained.</p>
  
  <p>The output should be:</p>
  
  <pre><code>ID ColA ColB
  1   7    8
  
  3   7    9
  4   5    8
  
  6   6    9
  7   5    4
  </code></pre>
  
  <p>How can this be done with mySQL?</p>
  
  <p>Thanks,
  Juergen</p>