Hi all,

I was working with a query as follows

"select first 3 skip 2 from table"

where in i was expecting the recordcount of the query to be 3, but it gave the recordcount of the following query

"select * from table"

not just that, when i navigated through the query i was able to retrieve the records which were skipped/or not selected.

Please help/guide me to a proper solution, i m using firebird 2.1.2 and ib 4.8.6