db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Legolas Woodland <legola...@gmail.com>
Subject Re: Using/Adressing a "row number" in a SELECT query
Date Fri, 17 Feb 2006 09:00:35 GMT
Sylvain RICHET wrote:
> Hi everyone,
> In a selection statement, i would like to get blocks of records.
> Thus, i need to filter records by a "row number", directly at the 
> SELECT level.
> 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..."
> In DB2 (on AS/400) , there is the "RRN" (Relative Record Number)...
> What about Derby database ?
> How is it implemented on this server ?
> I know i could use
> Thanks in advance. 
Derby sql does not has any facilities for limiting number of rows in 
select statement.
you can just limit the fetch size in JDBC resultSets.

View raw message