Re: Select Row

Joe, this won't work unless you are using GROUP BY clause in your SQL
statement.

Steve Landess
Austin, Texas
(512) 423-0935

----- Original Message ----- 
From: "Joe Giusto" <jgiusto@xxxxxxxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, May 16, 2003 6:01 PM
Subject: RE: Select Row


> Or how about
> Select iprod,iclas, count(*) from iim where count(*) <= 10
>
> <snip>
> > How to select only the first 10 rows in an interative SQL statement ?
>
> > Example for Select iprod,iclas from iim for 10 rows ???
>
> You can use relative record number rrn
> Select iprod,iclas from iim where rrn(iim) <= 10
>
> rrn is based on the physical and, assuming no deleted records, will return
> 10 rows.
> <snip>
>
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>