Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need some query help
Hi,
SQL> create table ftird (doc varchar2(50),FT number, dat date, ird number);
Tabel is aangemaakt.
SQL> merge into ftird a
2 using (select rowid rid, ft,doc,dat,ird,case when min(dat) over
(partition by ft,doc
3 order by dat)=dat then 1 else 0 end upd from ftird) b
4 on (a.rowid=b.rowid)
5 when matched then update set a.ird=b.upd
6 when not matched then insert (ird) values (null);
4 rijen zijn samengevoegd.
In 10g, you can skip the last line.
Regards,
Arian Received on Mon Feb 27 2006 - 08:09:30 CST