title: Using MAX and returning whole row with max column value
body: <p>I am new to SQL and struggling with finding a working solution for my MAX situation.</p>
  
  <p>I currently have a table that looks like:</p>
  
  <pre><code>ID   Date         Version
  001  2010-11-17   2
  001  2010-12-01   3
  002  2011-01-11   1
  002  2011-05-05   2
  </code></pre>
  
  <p>My desired result is simply:</p>
  
  <pre><code>ID   Date        Version
  001  2010-12-01  3
  002  2011-05-05  2
  </code></pre>
  
  <p>I can't use MAX and GROUP BY on date since Date is not distinct.</p>