Re: Stuck with simple Update

From: Gary Floam <floam_at_comcast.net>
Date: Wed, 22 Nov 2006 11:32:54 -0500
Message-ID: <yr2dnSAaqukm5vnYnZ2dnUVZ_rednZ2d@comcast.com>

For any row that has one of the id's null, the entire row would sum to null and not be included in the second query but the other id's in the row would contribute to the sums in the query. So the first query includes more terms than the second.

Hope this helps.

"Robert Klemme" <shortcutter_at_googlemail.com> wrote in message news:4sjamdFvi6gkU1_at_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:32:54 CST