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

The SQL must apply the change to the whole table as one piece of code (120000000+ rows, about 40000000 unique)

Cheers for the help though

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:o3uikukppud9094it145c5bds0nnbu5nfg_at_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 - 14:15:10 CDT