title: Find max value and show corresponding value from different field in SQL server
body: <p>I have a table with data about cities that includes their name, population and other fields irrelevant to my question. </p>
  
  <pre><code>ID      Name    Population
  1       A       45667   
  2       B       123456  
  3       C       3005    
  4       D       13769   
  </code></pre>
  
  <p>To find the max population is basic, but I need a resulting table that has the max population in one column, and the corresponding city's name in another column</p>
  
  <pre><code>Population      Name    
  123456          B       
  </code></pre>
  
  <p>I've looked through <a href="https://stackoverflow.com/questions/376518/how-to-get-the-record-of-a-table-who-contains-the-maximum-value">similar</a> questions, but for some reason the answers look over-complicated. Is there a way to write the query in 1 or 2 lines?   </p>