Subject | RE: [IBDI] Firebird 1 |
---|---|
Author | Ann W. Harrison |
Post date | 2001-05-31T16:35:26Z |
At 12:12 PM 5/31/2001 -0400, Ann W. Harrison wrote:
you really want just the hundred and eleventh to the hundred
and twentieth records and don't care about 1-111. Is that
likely?
Regards,
Ann
www.ibphoenix.com
We have answers.
>The problem I have with the syntax SELECT .... LIMIT (11, 20)Of course, SELECT ... LIMIT (111, 120) is reasonably good
>...
>If this were done as a single select, it would read 120 records.
>If it were done as individual limited selects, it would read
>over 6000 records. I suppose that doesn't matter.
you really want just the hundred and eleventh to the hundred
and twentieth records and don't care about 1-111. Is that
likely?
Regards,
Ann
www.ibphoenix.com
We have answers.