db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain RICHET <derb...@gmail.com>
Subject Re: Using/Adressing a "row number" in a SELECT query
Date Fri, 17 Feb 2006 10:55:37 GMT
Thanks Legolas,

... but limiting the fetch size by JDBC API supported methods (setFetchSize)
implies that i have already loaded ALL records from database, no ?

However, the datas persisted in my DERBY database concern logging. It means
that i would have to get thousands of records.

On 2/17/06, Legolas Woodland <legolas.w@gmail.com> wrote:
>
> 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.
>
>

Mime
View raw message