Subject Re: [ib-support] Restricting the No of Rows
Author Ajay
Thanks very much
----- Original Message -----
From: Lucas Franzen
To: ib-support@yahoogroups.com
Sent: Friday, November 29, 2002 6:02 PM
Subject: Re: [ib-support] Restricting the No of Rows




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.

Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]