4 ms·
I believe MySQL does exactly this, but it's been a number of years since I worked with it in any depth.
by Diederich 9y ago
I believe MySQL does exactly this, but it's been a number of years since I worked with it in any depth.
- default-kramer 9y agoAh, 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.html https://dev.mysql.com/doc/refman/5.5/en/group-by-handling.ht...