Hi,
I'm trying to understand which SQL language subset Derby is using. I
installed version 10.2.2.0 and tried to compile and execute the following
statement:
SELECT MIN(A) OVER (PARTITION BY B) FROM C;
(which seems a legal SQL-2003 statement). However, the Derby sql compiler
complains about the '(' after the 'OVER' keyword.
I looked into the sqlgrammar.jj file and could not find a "partition" or
"over" keyword at all. Is this not supported (yet)?
Or am I doing something wrong?
Thanks for clarifying,
Christian