Re: Select first/last n rows in SQL?

[rbaird@xxxxxxxxxxxxxxxxxxxxx]

Loyd,

I believe you are out of luck until you upgrade to V5.  I think I heard the
limit clause was added in the new release.

Rick

original message
Loyd sez:
>Is there a way I can select the first or last n (5, 10, whatever) rows
from
a database using SQL? Some other databases have a LIMIT clause. A query
like
SELECT DBXFIL FROM QADBXREF WHERE DBXLIB='QGPL' ORDER BY DBXFIL LIMIT 10;
would give me the first 10 files alphabetically in QGPL. (This is a
hypothetical example.) I'm primarily interested in "interactive" lookups
(not embedded SQL). Running at V4R5.<

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---