| Subject | RE: [firebird-support] Skip records |
|---|---|
| Author | Leyne, Sean |
| Post date | 2014-07-28T19:08:05Z |
Ann,
Given that FB doesn't have the notion of ROW_Number within a result set, I don't see how the OP can filter to only see every nth row.
Sean
>> On Jul 22, 2014, at 9:47 AM, "'checkmail' check_mail@... [firebird-I don't think that the answer matters.
>> support]" <firebird-support@yahoogroups.com> wrote:
>> I would like to read every n record, depending on number of records.
>
> Do you care if your results are repeatable? If so, you'll have to sort all the
> records then skip records in the result set.
Given that FB doesn't have the notion of ROW_Number within a result set, I don't see how the OP can filter to only see every nth row.
Sean