Johannes Alfänger wrote:

> We just decided to go for Interbase instead for MySQL when evaluating a
> new application.
>
> Now I discovered, that there seems to be now function in Interbase to
> navigate easily within a query result, for example to display only a
> limited number of rows at one time and to navigate forward and backwards
> within the result set. Just something like "limit 10,20" in an MySQL
> select statement.
>
> I am aware that this is a beginners question. And I guess this is a
> common problem! Does anyone have a hint how to find a solution without
> inventing the wheel anew by myself?

In Interbase:

Select *
from employee
order by last_name, first_name
rows 11 to 30

In Firebird:

Select first 20 skip 10 *
from employee
order by last_name, first_name

--
Milan Babuskov
http://fbexport.sourceforge.net