Quote:
Originally Posted by JarlH
You originally claimed
I said that you can have a column in the GROUP BY that is not in the SELECT list.
Here you are trying to do the opposite, a column id in the SELECT list which "is not contained in either an aggregate function or the GROUP BY clause".
|
Sorry for that, that was indeed incorrectly put on my side.
My example statement is valid for MySQL and that's what I wanted to point out (the shortcomings of grouping in MySQL)
Re-reading my posts from a "distance" I do understand the confusion.
Sorry again, next time I'll try to be more precise...