Christian Lang wrote: > Hi, > > I'm trying to understand which SQL language subset Derby is using. I ...
The Derby Wiki has a page that provides details about SQL support: http://wiki.apache.org/db-derby/SQLvsDerbyFeatures There's also a page that provides JDBC details: http://wiki.apache.org/db-derby/JDBCSupport regards, -jean > 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 >
