db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject [MOVE] Re: LIMIT clause in select query
Date Fri, 26 Aug 2005 15:49:15 GMT
Amit Modi wrote:

> Hi Mamta,
>    Thanks for the reply. I know about using  the JDBC api
> java.sql.Statement.setMaxRows() to limit
> the number of rows returned, but the problem here is it returns the top
> rows from the complete result.
> But suppose I want 50 rows and that too from 51 to 100 from the complete
> result, cannot be achieved using
> setMaxRows().
> So can you suggest some solution for this situation?

Please post any replies on the derby-user list (where the question was
originally asked).


View raw message