Hi Milan!

Thanks for helping so quick! I looked through the documentation last
night and did not find anything!

Hvala! Johannes

-----Ursprüngliche Nachricht-----
Von: Milan Babuskov [mailto:albis@...]
Gesendet: Donnerstag, 16. Oktober 2003 09:51
An: firebird-php@yahoogroups.com
Betreff: Re: [firebird-php] Limit number of rows to display - move
forward and backwards


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




To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/