title: SQL Server: Only last entry in GROUP BY
body: <p>I have the following table in MSSQL2005</p>
  
  <pre><code>id | business_key | result
  1 | 1 | 0
  2 | 1 | 1
  3 | 2 | 1
  4 | 3 | 1
  5 | 4 | 1
  6 | 4 | 0
  </code></pre>
  
  <p>And now i want to group based on the business_key returning the complete entry with the highest id.
  So my expected result is:</p>
  
  <pre><code>business_key | result
  1 | 1
  2 | 1
  3 | 1
  4 | 0
  </code></pre>
  
  <p>I bet that there is a way to achieve that, i just can't see it at the moment.</p>