title: SQL: Select a row only if that cell has the max value given the ID
body: <p>I realize the title of the question is much more difficult than the question itself.</p>
  
  <p>Basically I have a dataset like this one:</p>
  
  <pre><code>ID  Hour
  01  1
  01  2
  01  3
  02  1
  02  2
  03  1
  03  2
  03  3
  03  4
  </code></pre>
  
  <p>The dataset refers to people that are playing a game. ID is, of course, the ID of the subject whilst 'Hour' refers to what happened in that hour of game. Now, I would like to <strong>select only the rows that refer to the last hour played by that player</strong>.</p>
  
  <p>So that:</p>
  
  <pre><code>ID  Hour
  01  3
  02  2
  03  4
  </code></pre>
  
  <p>Any ideas?</p>