News for hackers. Stuff that matters.
Re:A query had to go by Diederich on Tuesday June 06, 2017 @04:24PM (#14500959)
I believe MySQL does exactly this, but it's been a number of years since I worked with it in any depth.
Re:A query had to go by default-kramer on Tuesday June 06, 2017 @11:36PM (#14503559)
Ah, I found it. It turns out if you include nonaggregated columns it will just pick one value from the group arbitrarily.

https://dev.mysql.com/doc/refman/5.5/en/group-by-handling.ht...