Subject Re: [firebird-support] Problem with select statement using FIRST
Author Helen Borrie
At 12:35 PM 27/09/2003 +0000, you wrote:
>I'm having a problem with the following select statement.
>select t1.*
>from table1 t1
>where in (select first 10 from table1 t2 where <
>order by
>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

Perhaps a combination of scrambled cursors and scrambled perception...

How is the output from this plain-jane query spec different to what you are
seeking to get:

select first 10 * from table1
where id < 100
order by name