title: How to delete duplicate rows with SQL?
body: <p>I have a table with some rows in. Every row has a date-field. Right now, it may be duplicates of a date. I need to delete all the duplicates and only store the row with the highest <code>id</code>. How is this possible using a SQL query?</p>
  
  <p>Now:</p>
  
  <pre><code>date      id
  '07/07'   1
  '07/07'   2
  '07/07'   3
  '07/05'   4
  '07/05'   5
  </code></pre>
  
  <p>What I want:</p>
  
  <pre><code>date      id
  '07/07'   3
  '07/05'   5
  </code></pre>