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 -> strange update

strange update

From: Marcin Buchwald <velvet_at_agora.pl>
Date: Mon, 31 Mar 2003 16:03:29 +0200
Message-ID: <b69i1h$rfm$1@pippin.warman.nask.pl>


select id from (select mak_xx,adno,czas_obow,min(xx) id,count(1) from spacer_pub where adno is not null group by mak_xx,adno,czas_obow having count(1)>1);

...

1413 rows selected

All the rows are different!

Next I wrote:

update spacer_pub set adno=null where xx in (select id from (select mak_xx,adno,czas_obow,min(xx) id,count(1) from spacer_pub where adno is not null group by mak_xx,adno,czas_obow having count(1)>1));

72 rows updated

(!!!) I expected 1413 rows to be updated

What about the other rows??

I am using ora817eent

Thanks in advance,

        Marcin Received on Mon Mar 31 2003 - 08:03:29 CST

Original text of this message

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