Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: update

Re: update

From: ctemp <ctemp01_at_hotmail.com>
Date: 10 Dec 2001 13:19:14 -0800
Message-ID: <4d44e6cf.0112101319.2dd527fc@posting.google.com>


update table t1
set value = (select max(value)
from table t2
where t1.code = t2.code
group by code); Received on Mon Dec 10 2001 - 15:19:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US