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: Need some query help

Re: Need some query help

From: Alien <stijf_at_stijf.com>
Date: 27 Feb 2006 06:09:30 -0800
Message-ID: <1141049370.520969.228150@j33g2000cwa.googlegroups.com>


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

Original text of this message

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