title: SQL Max on Group By
body: <p>I'm stuck at a very simple t-sql query. Please help !</p>
  
  <p>Following is my result set :</p>
  
  <pre><code>Percentage---FirstName---SessionId
  
  34-----------ABC---------222
  67-----------ABC---------333
  11-----------ABC---------444
  83-----------XYZ---------555
  23-----------XYZ---------666
  64-----------XYZ---------777
  </code></pre>
  
  <p>From above, I want records of each user with maximum percentage e.g.</p>
  
  <pre><code>Percentage---FirstName---SessionId
  67-----------ABC---------333
  83-----------XYZ---------555
  </code></pre>
  
  <p>I can't seem to do that and I'm in hurry. Please help at the earliest. Any help would be greatly appreciated.</p>
  
  <p>Thanks.</p>