The Rows Holding the Group-wise Maximum of a Certain Column

http://jan.kneschke.de/projects/mysql/groupwise-max/

아래와 같은 방법도 있다...

SELECT continent,
       SUBSTRING( MAX( CONCAT(LPAD(population,10,'0'),name) ), 10+1) AS name,
       MAX( population ) AS population
  FROM Country
 GROUP BY continent;

SELECT continent,
       SUBSTRING_INDEX(GROUP_CONCAT(name ORDER BY population, ','), ',', 1)) AS name,
       MAX( population ) AS population
  FROM Country
 GROUP BY continent;