Re: SQL: how to limit rows

[Aaron Abreu <abreual@xxxxxxxxxxxxx>]

It also works great for update sql's as welll

UPDATE "WORKROOM"/"WORKFILE"
SET
        WROOMNBR   = (SELECT SUBSTR(ROOMNBR,1,4)
                      FROM "ROOMLIB"/"ROOMFILE"
                      WHERE (WFLOORNBR = FLOORNBR  AND
                             SUBSTR(ROOMNBR,1,1) > '0')
                      ORDER BY FLOORNBR
                      FETCH FIRST ROW ONLY)
--
WHERE EXISTS
 (SELECT FLOORNBR
    FROM "ROOMLIB"/"ROOMFILE"
    WHERE (WFLOORNBR = FLOORNBR  AND
           SUBSTR(ROOMNBR,1,1) > ' '))





On Tue, Jul 31, 2012 at 5:15 PM, Darryl Freinkel <
dfreinkel@xxxxxxxxxxxxxxxxx> wrote:

> Note that the use of
>
> Fetch first nnnn rows only
>
> Works only for the primary select clause. It is not supported in the
> sub-select clauses.
>
> Darryl Freinkel | Assignment 400 Group, Inc.
> Tel: 770.321.8562 ext 111 | Fax 770.321.8562
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.