title: row with max value per group - SQLite
body: <p>Given a table with <code>columns(name, lat, lon, population, type)</code> where there are many rows for each <strong>name</strong>, I'd like to select the rows grouped by <strong>name</strong> where <strong>population</strong> is the highest. The following works if I restrict myself to just name and population</p>
  
  <pre><code>SELECT name, Max(population) 
  FROM table WHERE name IN ('a', 'b', 'c') 
  GROUP BY name;
  </code></pre>
  
  <p>But I want the other columns — <code>lat, lon, type</code> — as well in the result. How can I achieve this using SQLite?</p>