title: TOP 1 Query from each ID with multiple instances
body: <p>This query will return the top for all rows in MS Access.</p>
  
  <pre><code>SELECT TOP 1 * FROM [table]
  ORDER BY table.[Date] DESC;
  </code></pre>
  
  <p>I need to return the top date for each id that can have multiple dates.</p>
  
  <pre><code>ID      DATE
  1      01/01/2001
  1      01/12/2011
  3      01/01/2001
  3      01/12/2011
  </code></pre>
  
  <p>Should return only the top dates like this.</p>
  
  <pre><code>1      01/12/2011
  3      01/12/2011
  </code></pre>