No, because it is still going to have to walk through the records on the
server. In fact, potentially twice with what you have here.
The way I have done it allows you to use a descending index to immediately
grab the records needed.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Sandeep" <sandeep@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, November 11, 2001 6:17 PM
Subject: [IBO] TIBOTable Last


> Hi Jason
>
> Can something like
>
> select
> first 10
> skip ((select count (fieldA) from tableA) - 20)
> * from tableA
>
> be exploited to speed up the last operation in table
>
> Regards
>
> Sandeep
>
> Software Developer
> CFL
> sandeep@...
> http://www.cfl.co.nz
>