Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dilemma
Something like this perhaps?
update mytable t1 set end_date =
( select min(start_date) from mytable t2
where t2.start_date < t1.start_date);
Received on Mon Mar 13 2006 - 07:08:54 CST