This is a logic question (or at least I think it is).
What happens when the select term and group by term do not match? Why?
The sample code is here:
SELECT [B]Name[/B], max(Age)
FROM People
GROUP BY [B]Name[/B]
So what happens if those two bolded field names do not match (i.e. one of them was replaced with another field name)?
Another question which is similar:
Why can't you have B in:
SELECT count(*), A, [B]B[/B]
FROM C
GROUP BY A
So, field B should not be present. Why is that?
Thank you.