title: SQL: Select Multiple Columns with Max() on calculated values
body: <p>Real basic:  I have table T with following data:</p>
  
  <pre><code>ID   StartDate  Term (months)
  ----------------------
  1    10/1/2012   12
  2    10/1/2012   24
  3    12/1/2012   12
  </code></pre>
  
  <p>I need to know the ID of the row that has the max end date.  I've successfully calculated the end date as
  select  max( DateAdd(month, term, StartDate) from table  [this would result in 10/1/2014]</p>
  
  <p>how do i get the ID value and Start Date of the row that contains the max end date?</p>