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!
