Re: Stuck with simple Update

pankaj_wolfhunter_at_yahoo.co.in ha escrito:

> Greetings,
> This may sound a stupid question but I dont know where else to go.
>
> SQL> SELECT SUM(id1) - (SUM(id2) + SUM(id3)) RESULT
> 2 FROM table1
>
> RESULT
> ----------
> 225584455
>
> SQL> SELECT SUM(RESULT_TMP) RESULT
> 2 FROM (
> 3 SELECT id1 - (id2 + id3) RESULT_TMP
> 4 FROM table1
> 5 );
>
> RESULT
> ----------
> 225572755
>
> Why am I getting two different results.
> What am I dng wrong here?
>
> I am using Oracle 10g Enterprise Edition
>
> Any help would be greatly appreciated.
>
> TIA
NULL values:

sql> create table a (id1 number, id2 number, id3 number);

Tabla creada.

sql> insert into a values (1,null,null);

1 fila creada.

sql> insert into a values (null,2,null) ;

1 fila creada.

sql> insert into a values (null,null,3);

1 fila creada.

sql> insert into a values (4,4,4);

1 fila creada.

sql> SELECT SUM(RESULT_TMP) RESULT
  2 FROM ( SELECT id1 - (id2 + id3) RESULT_TMP FROM a);

    RESULT

        -4

sql> SELECT SUM(id1) - (SUM(id2) + SUM(id3)) RESULT from a;

    RESULT

        -8

sql> Received on Wed Nov 22 2006 - 10:06:53 CST