Subject | Select First x skip y question |
---|---|
Author | Lou Feliz |
Post date | 2001-08-31T00:37:40Z |
Hello.
First, it is great that this capabilit is in FB. I was trying it out
and observerd the following behaviour:
Table with 12 rows.
Select first 5 * from table
Result returns the 5 top rows.
Select first 5 skip 5 * from table
Result returns rows 5 to 9, not 6 to 10 as I expected.
Is this the normal behaviour? It is not a problem, sometimes nice to
know the last record in prior fetch is the first in the next set.
- Lou
First, it is great that this capabilit is in FB. I was trying it out
and observerd the following behaviour:
Table with 12 rows.
Select first 5 * from table
Result returns the 5 top rows.
Select first 5 skip 5 * from table
Result returns rows 5 to 9, not 6 to 10 as I expected.
Is this the normal behaviour? It is not a problem, sometimes nice to
know the last record in prior fetch is the first in the next set.
- Lou