--- In firebird-support@yahoogroups.com, Michael Weissenbacher
<mw@...> wrote:

>
> Hi,
> > I just came across a query:
> >
> > SELECT ID FROM table WHERE ID IN
> > (SELECT FIRST 2 ID FROM table)
> >
> > (ID is primary key. The table has 10 records)
> >
> > How many records does it return, 2 or 10? I got 10, which is the

same as

> >
> > SELECT ID FROM table WHERE ID IN
> > (SELECT ID FROM table)
> >
> > Does "first 2" work in subquery?
> >
> No, see the relase notes. AFAIK it works in 2.0, but i'm not sure.
>
> Michael
>

I see. I am using 1.5.2