RE: Select first/last n rows in SQL?

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

You will have to use a key of some sort (even if it's RRN).  You would
either sort ASC or DESC and just grab the first n rows. 

Brad

> -----Original Message-----
> From: Goodbar, Loyd (AFS-Water Valley) 
> [mailto:LGoodbar@afs.bwauto.com]
> Sent: Friday, May 18, 2001 2:20 PM
> To: 'MIDRANGE-L@midrange.com'
> Subject: RE: Select first/last n rows in SQL?
> 
> 
> 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
> +---
> 
+---
| 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
+---