Re: RE: No order by in a subselect

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Turns out the order by has always been there (at lease since v4r4). The
trick was to leave off the parentheses. I don't know about subselects in a
WHERE clause, e.g. But in an INSERT INTO, it seems that any valid SELECT
should work, WITHOUT the parentheses.

FETCH FIRST N ROWS ONLY appeared in v5r1. They both appear in WHERE clause
subselects in v5r2. They were put in to support some of the things you find
in the TPC-W benchmark.

At 10:58 AM 7/8/02 -0400, you wrote:
>Rob, how about this:
>
>INSERT INTO DIRBIG
>(SELECT IFSLDIR, IFSLOBJ, IFSLSIZ, CURRENT DATE FROM IFSLIST)
>ORDER BY IFSLSIZ DESC
>FETCH FIRST 20 ROWS ONLY