Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: difficult? sql statement
this works but it's ugly.
update b set data = (select data from
a where a.partno = b.partno and rownum =1 and
weight = (select max(weight) from a where a.partno = b.partno))
rbarrett_at_solutionpt.com
Oracle DBA
Received on Mon Jan 12 1998 - 00:00:00 CST