Re: Stuck with simple Update

Gary Floam wrote:
> 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

Thanks ppl. I really feel like kicking myself :-) Received on Wed Nov 22 2006 - 10:58:35 CST