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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 01 Aug 2002 20:07:01 +0200
Message-ID: <o3uikukppud9094it145c5bds0nnbu5nfg@4ax.com>

On Thu, 1 Aug 2002 16:06:36 +0100, "Dave Siddons" <davesiddons_at_yahoo.com> 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
>
>
>

update emp
set ... = ...
where id = :b1
and end_date =
(select max(end_date)
from emp e1
where e1.id = emp.id
)

Homework.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Aug 01 2002 - 13:07:01 CDT