--- In firebird-support@yahoogroups.com, Ali Gökçen <ali_gokcen@...>
wrote:

>
> Here is rocket tech:
>
> select t1.id,t1.name from table1 t1
> join table1 t2
> on t2.id<(select first 1 skip t1.qty id from table1 order by id)
>
> good luck to u on the sql space..
>
> Ali
>

ops.. field test fault!
skip t1.qty refused by FB(interesting), my test was with parameter.
my rocket crashed again! ;)

but this doesn't stop me, i will skip this problem with any way.

Ali