You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Daniel John Debrunner <dj...@debrunners.com> on 2005/08/26 17:49:15 UTC

[MOVE] Re: LIMIT clause in select query

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).

Thanks,
Dan.