db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ramakishore <kish...@ttsiglobal.com>
Subject Pagination support in Derby some thing like LIMIT in Mysql and Rownum in Oracle
Date Tue, 28 Aug 2007 17:13:12 GMT

We need to implement the pagination solution using the Derby DB.
For example if a make a query select * from table a.  I want to retrieve
records from 1 to 100, 101 to 200, 201 to 300 etc.. using some thing like
LIMIT with offset etc..
I am looking for any derby database features to support this featue.
View this message in context: http://www.nabble.com/Pagination-support-in-Derby-some-thing-like-LIMIT-in-Mysql-and-Rownum-in-Oracle-tf4342993.html#a12372108
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message