>>>Try

Select mytable
>>>SET ORDER TO
>>>SET FILTER TO < your condition >
>>>GO BOTTOM
>>>SKIP -9
>>>COPY REST TO result
>>>

>>
>>Yes, that would work. I thought of that in the first place. It's just that I don't want to use any SET FILTER command. Otherwise, I would have to take care of resetting it after and this may cause some problems on other logics especially if maintained by other developers.
>
>In this case you can open table again

USE mytable again IN 0 ALIAS temp1
>Select temp1
>* the rest of code
>...
>USE IN temp1

Yeah, that would work.

It'd be nice if SELECT FIRST 10 would be supported as well as SELECT LAST 10.