title: Get last value based on an Id in SQL Server 2005
body: <p>Consider my query,</p>
  
  <p><code>Select EmpId,RemainingBalance from Salary where EmpId='15'</code></p>
  
  <p>My results pane,</p>
  
  <blockquote>
    <p>15 450.00<br>
    15 350.00<br>
    15 250.00</p>
  </blockquote>
  
  <p>How to get last RemainingBalance amount (ie) <code>250.00</code>...</p>