title: SQL selecting multiple columns and MAX from one of the columns, only one row to be returned
body: <p>I need to select multiple columns from a table, together with a max value from one of the columns
  The result must be only that one row where the max value is in.
  Here's a simplified version of my table (sorry, don't know how to insert spaces)</p>
  
  <pre><code>╔═════════╦══════════╦═══════════╗
  ║ CARMAKE ║ CARMODEL ║ CARWEIGHT ║
  ╠═════════╬══════════╬═══════════╣
  ║ A       ║ B        ║      1000 ║
  ║ C       ║ D        ║       900 ║
  ╚═════════╩══════════╩═══════════╝
  </code></pre>
  
  <p>The desired result would be</p>
  
  <pre><code>╔═════════╦══════════╦═══════════╗
  ║ CARMAKE ║ CARMODEL ║ CARWEIGHT ║
  ╠═════════╬══════════╬═══════════╣
  ║ A       ║ B        ║      1000 ║
  ╚═════════╩══════════╩═══════════╝
  </code></pre>
  
  <p>But when I use </p>
  
  <pre><code>SELECT carmake, carmodel, MAX(carweight)
  FROM   car
  GROUP  BY carmake, carmodel
  </code></pre>
  
  <p>It will show the max of each make etc. instead of only the row with the absolute max. How can I do that?</p>