title: SQL Group By: Get values of 'max' record
body: <p>I have a <code>scores</code> table:</p>
  
  <pre><code>id
  user
  score
  date
  </code></pre>
  
  <p>Now, I can easily select a top 10 highscore with</p>
  
  <pre><code>SELECT user, score, date FROM scores ORDER BY score DESC
  </code></pre>
  
  <p>However, I'd like to include only one score per user, namely his highest. I would begin with something like</p>
  
  <pre><code>SELECT user, MAX(score) AS score FROM scores GROUP BY user ORDER BY score DESC
  </code></pre>
  
  <p>However, now I've lost the <code>date</code> that highest score was recorded. How do I get it?</p>