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

 PG> select distinct process_date from proc_table order by process_date

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

Since you can never assume anything about the sequence of an SQL result
set,  I would have solved this problem before it occurred by adding a
unique row identifier.

If you can't (or don't want to) change the original table,  the only way I
can see out of this is to create a temp table (perhaps with SELECT INTO), 
add the unique row identifier by using an UPDATE command that specifies
each of the other fields (if you have duplicate rows you are in big trouble
and deserve everything you get!).


--- Maximus/2 3.00