db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik" <dag.wan...@oracle.com>
Subject Re: Window functions in Derby
Date Mon, 16 May 2011 20:56:09 GMT
On 14.05.2011 15:39, Lukas Eder wrote:
>  From what I understand, Derby's long-term goal is to support window
> functions in the SQL:2003 standard way, as many other RDBMS do already
> (I know of DB2, Oracle, Postgres, SQL Server and Sybase providing
> extensive support). Are there any such plans in the near future at
> Derby?
Only the ROW_NUMBER window function is currently implemented. I know of 
no plans to extend this
as of now.  http://db.apache.org/derby/docs/10.8/ref/rreffuncrownumber.html
It is not all the useful on its own, since Derby also supports the newer 
(SQL:2008) OFFSET/FETCH FIRST (NEXT) functionality,
cf http://db.apache.org/derby/docs/10.8/ref/rrefsqljoffsetfetch.html

Thanks,
Dag

Mime
View raw message