Re: Problem updating latest value (date) column for a given key

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 01 Aug 2002 20:52:33 GMT
Message-ID: <3D499F8E.2C3CFD82@exesolutions.com>

Dave Siddons wrote:

> 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

It seems pretty obvious you are a student looking for someone to do your homework for you ... so ... what you get is a hint rather than a solution.

Look at the MAX function. And consider in what ways a sub-query might be of value.

Daniel Morgan Received on Thu Aug 01 2002 - 15:52:33 CDT