The SELECT FIRST... syntax will only allow the first n rows to be
returned. Have you though instead of fetching only the rows required?
All rows aren't returned automatically. You should be able to fetch
only the number you desire without changing the SQL.

Louis Kleiman
SSTMS, Inc.

-----Original Message-----
From: Svein Erling Tysvær
[mailto:svein.erling.tysvaer@...]
Sent: Friday, June 07, 2002 10:40 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Reducing the numbers of records returned

>Is it possible, and if so how, to reduce the number of record
>returned by a query without changing the query?

No, it isn't. But if you're using Firebird, the required change is
minimal.

>For exmaple if I had a table called table1 that contained 10,000
>records and I wrote a query of : select field1, field2 from table1.
>This obviously will return all of the records, but what I want to do
>is have that query but reduce the result set to say ten records.

select first 10 field1, field2 from table1.

Set


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.