It seems unlikely that everyone is wrong.
Even unlikelier that I am right! but -
SELECT COL1,COL2,COL3 FROM TABLE1 GROUP BY COL1
works!
However,
SELECT COL2,COL3 FROM TABLE1 GROUP BY COL1
does NOT work.
So doesn't that mean that "A" is, in fact true?
Rav
Please Ignore my previous post.
Doh! Doh! Doh!
Actually A is not fully true. For instance,
You can say
SELECT col1, col2, max(col3) from TableA GROUP BY col1, col2
Therefore col3 is not technically in the group by clause.
I could be wrong. Its early and I have not had my coffee yet. But I think the above is true.
Far away is close at hand in the images of elsewhere.
Anon.
