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 13:22:11 GMT
Sylvain RICHET wrote:
> Thanks Legolas, for your explanations.
>
You are welcome.
it was my first time that i could help a member in mailing list
so far i just request for help in past days.
now i am happy ;-)
> On 2/17/06, *Legolas Woodland* <legolas.w@gmail.com 
> <mailto:legolas.w@gmail.com>> wrote:
>
>     Sylvain RICHET wrote:
>>     Though it is astonishing there is no way to address/access the
>>     "row number" on DERBY , whereas it's possible with other database
>>     systems...
>>
>>     Have you ever heard about any workaround ?
>     I dont think that you can find a workaround for this.
>     if you file a Jira entry i will vote for it.
>     Thanks
>
>>
>>     On 2/17/06, *Legolas Woodland* <legolas.w@gmail.com
>>     <mailto:legolas.w@gmail.com>> wrote:
>>
>>         Sylvain RICHET wrote:
>>>         Thanks Legolas,
>>>
>>>         ... but limiting the fetch size by JDBC API supported
>>>         methods (setFetchSize) implies that i have already loaded
>>>         ALL records from database, no ?
>>>
>>         I asked about this feature  sometimes before.
>>         it is not present in current derby version , but you can vote
>>         on its jira entry or create a jira entry for it.
>>
>>          
>>>         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
>>>         <mailto: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