title: SQL Server select max date per ID
body: <p>I am trying to select max date record for each service_user_id for each finance_charge_id and the amount that is linked the highest date</p>
  
  <pre><code>select distinct 
      s.Finance_Charge_ID, MAX(s.start_date), s.Amount  
  from
      Service_User_Finance_Charges s
  where 
      s.Service_User_ID = '156'
  group by 
      s.Finance_Charge_ID, s.Amount
  </code></pre>
  
  <p>The issue is that I receive multiple entries where the amount is different.  I only want to receive the amount on the latest date for each finance_charge_id</p>
  
  <p>At the moment I receive the below which is incorrect (the third line should not appear as the 1st line has a higher date)</p>
  
  <pre><code>Finance_Charge_ID   (No column name)    Amount
  2                      2014-10-19       1.00
  3                      2014-10-16       500.00
  2                      2014-10-01       1000.00
  </code></pre>