title: Select additional column value in group by
body: <p>Please see the mysql table data below. What I would like to do is to have the MIN(price) per date, but select the matching some_id as well. </p>
  
  <pre><code>SELECT date, MIN(price), some_id
  FROM table
  GROUP BY date
  </code></pre>
  
  <p>That doesn't work since mysql 5.7 introduced full group by mode as it's default.</p>
  
  <p>Any ideas? Note that it's a massive table with millions of rows.</p>
  
  <pre><code>date        price   some_id
  2016-04-09  10.66   3535475
  2016-04-09  11.53   2429075
  2016-04-09  11.53   2119575
  2016-04-09  12.53   1431700
  2016-04-09  12.55   2119375
  2016-04-10  8.58    885050
  2016-04-10  13.20   3535475
  2016-04-10  14.27   2429075
  2016-04-10  14.27   2119575
  2016-04-10  14.70   13591
  2016-04-11  11.98   885050
  2016-04-11  12.44   2119375
  2016-04-11  13.00   3535475
  2016-04-11  13.79   2119575
  2016-04-11  14.27   2429075
  2016-04-11  14.91   13409
  2016-04-11  15.38   2152375
  2016-04-11  15.64   1431700
  </code></pre>