Hi,

    A few weeks ago I posted a message asking if anyone could tell me
if there is a way to pick the Nth row of a query.  For example :

select distinct process_date from proc_table order by process_date

How would I get the 6th (or the 7th, 8th, etc.) date in that set?  Trick
is NOT to use a cursor and a loop.  There must be a way to do this
(perhaps using RIDS?) in DB2 or Oracle.

Thanks

Peter

--- WILDMAIL!/WC v4.12 
(1:100/4.0)