update

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 Received on Mon Dec 10 2001 - 08:33:09 CST