RE: DB2 Question

Phil,

RRN solutions don't work as they rely on the physical order of the data, not
of the logical order.

What the person is looking for is...

select * from table
  (select * from
    (select * from table where...
       order by column fetch first 75 rows only) as t1
    order by column desc fetch first 25 rows only) as t2
order by column

Sorry for my remark about TOP... it was just the concept I was trying to
explain.

Kind regards,
Paul 

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of phil.groschwitz@xxxxxxxxx
Sent: donderdag 4 mei 2006 15:46
To: Java Programming on and around the iSeries / AS400
Subject: RE: DB2 Question


would this work?

SELECT * FROM DB2ADMIN.ST_ITEM a
 where rrn(a) between 50 and 75

Is TOP supported on the iSeries?  I can't find it in the manuals.  The
closest I found was "fetch first nn rows".

Phil




--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/java400-l.