You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Sylvain RICHET <sr...@axiliance.com> on 2006/02/16 15:57:21 UTC

Select queries using a "row number" implementation ?

Hi everyone,

In a selection statement, i would like to get blocks of records filtred
by "relative record number".

It seems that the way to address a row number is not (SQL) standard
(different "proprietary" implementations) 

In Oracle, there is the "rowid".
In MySQL, the "LIMIT" clause can do it.
In SQL Server, i think there is the "ROW_NUMBER() OVER..."
On AS/400 + DB2 , there is the "RRN" (Relative Record Number)...

What about Derby database ?
How is it implemented on this server (especially in the embedded mode) ?

Thanks in advance.