Re: Stuck with simple Update

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 22 Nov 2006 17:03:27 +0100
Message-ID: <4sjamdFvi6gkU1@mid.individual.net>

On 22.11.2006 16:48, pankaj_wolfhunter_at_yahoo.co.in wrote:
> 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 );

This should be equivalent to

select sum(id1 - (id2 + id3)) result
from table1;

> 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.

And you are sure that the data did not change in between? Other than that numeric issues (rounding errors or data type limits) come to mind.

robert Received on Wed Nov 22 2006 - 10:03:27 CST