Hi,

I am trying a statement like:
SELECT count(*) FROM table1 GROUP BY YEAR(table1.the_time);
I found it's OK in systems like DB2. But "syntax error" was given when I
tried on Derby.

So does it mean GROUP BY in Derby can only be followed by a real column
instead of some extra decoration?
And if not, how could I do something like to group by null and not null
like:
SELECT count(*) FROM table1 GROUP BY IS NULL(table1.the_time);

Thanks!

Reply via email to