Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Problem updating latest value (date) column for a given key
Hi,
I have 2 relevant columns
ID and END_DATE
For each person in this table (identified by ID) there will many rows in the table, each representing a position held within the company. Each END_DATE is the END_DATE representing the date they left that position. I need a fast way (SQL or PL/SQL with or without new indexes) to update the latest END_DATE for each ID in the table.
Any ideas anyone.
Thanks for any help received .....
Dave Received on Thu Aug 01 2002 - 10:06:36 CDT