title: How to filter mysql duplicated id rows and retrieve the one with latest timestamp?
body: <p>I have a mysql table with entries like this:</p>
  
  <pre><code>id  name        value   date
  1   results1    1000000 2010-06-02 01:31:12
  2   results2    600000  2010-09-03 05:42:54
  1   results1    1200000 2010-09-06 02:14:36
  </code></pre>
  
  <p>How can I SELECT all and filter multiple rows that have the same id, selecting only the one with latest date?</p>
  
  <p>The "date" column datatype is timestamp and it has CURRENT_TIMESTAMP as default.</p>