Subject Re: [ib-support] Restricting the No of Rows
Author Lucas Franzen
Ajay schrieb:
>
> hi
> Is there any way by which you can restrict the no of rows returned in FireBird (eg 1 to 200)

SELECT FIRST <N> SKIP <M> <FIELDS> FROM ...

N = Number of rows returned
M = Number of records to skip before selecting.

Luc.