Re: RE: No order by in a subselect

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Amazing.  That worked.  And all it involved was moving a parenthesis from
the end of the statement (after the word ONLY) to right after the file
name.

Thank you.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Mike Naughton" <mnaughton@juddwire.com>
Sent by: midrange-l-admin@midrange.com
07/08/2002 09:58 AM
Please respond to midrange-l


        To:     midrange-l@midrange.com
        cc:
        Fax to:
        Subject:        Re: RE: No order by in a subselect


Rob, how about this:

INSERT INTO DIRBIG
(SELECT IFSLDIR, IFSLOBJ, IFSLSIZ, CURRENT DATE FROM IFSLIST)
ORDER BY IFSLSIZ DESC
FETCH FIRST 20 ROWS ONLY

midrange-l@midrange.com writes:
>Thanks for the try Gord, but from STRSQL:
>
>With TEMP AS (SELECT IFSLDIR,IFSLOBJ,IFSLSIZ,CURRENT DATE
>       FROM IFSLIST
>       ORDER BY IFSLSIZ DESC
>       FETCH FIRST 20 ROWS ONLY)
>Insert into dirbig (Select * from TEMP)
>Keyword ORDER not expected. Valid tokens: ).
>
>Rob Berendt


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.