title: Selecting in SQL Server 2008
body: <p>I  have table   </p>
  
  <pre><code>ID       Name        Book   
  1        Aaron       HTML
  2        Charles     DESIGN
  3        Mark        SQL
  4        Charles     JAVA
  5        Charles     C++ 
  6        Mark        C#
  </code></pre>
  
  <p>I want to <code>SELECT</code> the rows with the greatest <code>ID</code> per  <code>Name</code>, having a result is like this:</p>
  
  <pre><code>ID       Name        Book   
  1        Aaron       HTML
  5        Charles     C++ 
  6        Mark        C#
  </code></pre>
  
  <p>Thanks in advance.</p>