RE: Select first/last n rows in SQL?

["Alexei Pytel" <pytel@xxxxxxxxxx>]

It's not LIMIT clause, it's
FETCH FIRST n ROWs ONLY   clause

    Alexei Pytel





                                                                                
                   
                    "Goodbar, Loyd                                              
                   
                    (AFS-Water Valley)"       To:     
"'MIDRANGE-L@midrange.com'"                  
                    <LGoodbar@afs.bwaut        <MIDRANGE-L@midrange.com>        
                   
                    o.com>                    cc:                               
                   
                    Sent by:                  Subject:     RE: Select 
first/last n rows in SQL?    
                    owner-midrange-l@mi                                         
                   
                    drange.com                                                  
                   
                                                                                
                   
                                                                                
                   
                    05/18/2001 02:19 PM                                         
                   
                    Please respond to                                           
                   
                    MIDRANGE-L                                                  
                   
                                                                                
                   
                                                                                
                   



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