RE: Select first/last n rows in SQL?

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

Yes, but I want the first 5 or last 5 items. Think about a web news site,
such as the yahoo personalized site (my.yahoo.com), showing the most recent
5 headlines. This is trivial in RPG, and could probably be done easily if we
had the SQL development kit (on the list and in the budget) through a cursor
and OPTIMIZE FOR x ROWS. I am looking for a method to use with RUNSQLSTM or
the QMQRY equivalence. Other databases (notably MySQL and PostgreSQL on
*NIX) have a LIMIT clause. The V5R1 reference doesn't show a limit clause,
either....

Loyd

-----Original Message-----
From: MacWheel99@aol.com [mailto:MacWheel99@aol.com]
Sent: Friday, May 18, 2001 1:41 PM
To: MIDRANGE-L@midrange.com
Subject: Re: Select first/last n rows in SQL?


If you looking at the table in sequence by what you want first/last of, 
consider MINimum MAXimum values.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)


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