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