Select first/last n rows in SQL?

["Goodbar, Loyd (AFS-Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>]

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.

Thanks!
Loyd

--
Loyd Goodbar
Programmer/Analyst
BorgWarner Incorporated
Air/Fluid Systems, Water Valley, MS



+---
| 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
+---