Hi,

I'm having a problem with the following select statement.

select t1.*
from table1 t1
where t1.id in (select first 10 t2.id from table1 t2 where t2.id <
100)
order by t1.name

This example will give all the records of the dataset but I only
want 10 records of the dataset.

Is there a problem with the select statement or is it a bug in
Firebird?

I'm using Fb V1.5 rc6.

regards,

Andy