title: Select by latest timestamp
body: <p>I have a following table :</p>
  
  <pre>
  +-------+--------+---------------------+
  | score |  user  |      scrap_time     |
  +-------+--------+---------------------+
  |  200  |  Bob   | 2015-09-08 11:46:17 |
  +-------+--------+---------------------+
  |  210  |  Alice | 2015-09-08 11:46:17 |
  +-------+--------+---------------------+
  |  240  |  Bob   | 2015-09-08 11:48:00 |
  +-------+--------+---------------------+
  |  260  |  Alice | 2015-09-08 11:48:01 |
  +-------+--------+---------------------+
  
  </pre>
  
  <p>I want to get all the scores for <em>each user</em> that have the <em>latest</em> <code>scrap_time</code> and ignore the older ones. </p>
  
  <p>Example:</p>
  
  <pre>
  +-------+--------+---------------------+
  | score |  user  |      scrap_time     |
  +-------+--------+---------------------+
  |  240  |  Bob   | 2015-09-08 11:48:00 |
  +-------+--------+---------------------+
  |  260  |  Alice | 2015-09-08 11:48:01 |
  +-------+--------+---------------------+
  
  
  </pre>
  
  <p>I have been trying to come up with a query, like this one :</p>
  
  <pre><code>select * from scores where date(scrap_time) = ( select max(scrap_time) from scores);
  </code></pre>
  
  <p>But this does not give me the results I need.</p>