title: SQL retrieving max value plus corresponding another column value
body: <p>Suppose I have following table in my database</p>
  
  <pre><code>      A        B          C       D          E
      2009    db1234      12345   1234567     3000
      2010    db1235      34567   1234567     3100
      2011    cn2345      23456   2345678     2800
      2010    db1236      12345   1234567     3100
      2012    db1237      34567   1234567     2800 
  </code></pre>
  
  <p>if I do max function on table A I would get 2012.
  I want query to return A and corresponding C column value i.e. 34567, In SQL.</p>