Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: update
"Francesco Zavatarelli" <fzavat_at_tiscalinet.it> a écrit dans le message news:
9v2kd6$itf$1_at_pegasus.tiscalinet.it...
> I have this table:
>
> code value
> 1 1000
> 1 2000
> 1 3000
> 2 1000
> 2 5000
> ... ...
>
> I want to set value to max(value) inside a GROUP
> i.e I want to get this:
>
> code value
> 1 3000 (changed from 1000 to 3000)
> 1 3000 (changed from 2000 to 3000)
> 1 3000
> 2 5000 (changed from 1000 to 5000)
> 2 5000
> ... ...
>
> which is the UPDATE statemet I have to use?
> thanks
> FZ
>
>
>
You can try this :
update toto a set value = (select max(value) from toto b where b.code =
a.code);
Received on Mon Dec 10 2001 - 10:55:11 CST