Re: Using/Adressing a "row number" in a SELECT query

[Legolas Woodland]

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.