title: Sort max score in time length of each player
body: <p>My Database structure</p>
  
  <pre><code>Table 'Player'   : column 'id'
  Table 'Score'    : column 'player_id' , 'score' , 'time'
  </code></pre>
  
  <p>example data in Table 'Score'</p>
  
  <pre><code>   player_id       score             time
       1001           100      2000-01-01 00:00:00
       1001             3      2012-08-01 00:00:00
       1001            11      2012-08-02 00:00:00
       1002            80      2012-07-01 00:00:00
       1002             5      2012-08-01 00:00:00
       1003            90      2012-07-01 00:00:00
  </code></pre>
  
  <p>I try to use</p>
  
  <pre><code>SELECT * FROM Score WHERE MONTH(time) = MONTH(NOW()) ORDER BY score DESC
  </code></pre>
  
  <p>The result from Player 1001 will be multiple row of score 11 and 3.<br/>
  How to sort and get only max score in time length that should be only score 11 of Player 1001</p>
  
  <p>The result should be</p>
  
  <pre><code>   player_id       score             time
       1001            11      2012-08-02 00:00:00
       1002             5      2012-08-01 00:00:00
  </code></pre>
  
  <p>not</p>
  
  <pre><code>   player_id       score             time
       1001            11      2012-08-02 00:00:00
       1001             3      2012-08-01 00:00:00
       1002             5      2012-08-01 00:00:00
  </code></pre>