Re: GROUP BY can only be followed by a real column?

[Bryan Pendleton]

sin(EaTing), wrote:

Thanks all.

Probably there is a version mismatch. I am using Derby 10.1 and this gives out an syntax error. I guess possibly it's already enhanced in newer versions.

Yes, definitely. Derby 10.2 added support for GROUP BY expressions:
https://issues.apache.org/jira/browse/DERBY-883

thanks,

bryan

P.S. 10.1 is fairly old now; Derby 10.4 has already been released!