Subject RE: [ib-support] Reducing the numbers of records returned
Author Louis Kleiman
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

-----Original Message-----
From: Svein Erling Tysvær
Sent: Friday, June 07, 2002 10:40 AM
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

>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.


To unsubscribe from this group, send an email to:

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