|Subject||Re: Not work when subquery uses "select first nn"?|
--- In email@example.com, "Leyne, Sean" <Sean@...> wrote:
>Nope, the "first 2" was still not picked up.
> > How many records does it return, 2 or 10? I got 10, which is the same
> > SELECT ID FROM table WHERE ID IN
> > (SELECT ID FROM table)
> > Does "first 2" work in subquery?
> Try this SQL:
> SELECT T1.ID FROM table T1 WHERE T1.ID IN (SELECT first 2 T2.ID FROM
> table T2)