RE: Consistent Null Handling

From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
To: lex.de.haan@xxxxxxxxxxxxxx
Date: Fri, 3 Sep 2004 06:13:57 -0700

I don't get that. Under what circumstances will sum(x) and sum(nvl(x,0)) give 
different results? I can see it for avg, but for sum?

Quoting Lex de Haan <lex.de.haan@xxxxxxxxxxxxxx>:

> Note however that the following three Oracle expressions are (and always
> have been) *different*
> that is, they give *different* results under certain conditions:
> 
> - sum(x)
> - sum(nvl(x,0))

-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/

Follow-Ups:

RE: Consistent Null Handling
From: Lex de Haan

RE: Consistent Null Handling
From: Steve Rospo

References:
- RE: Consistent Null Handling
  - From: Lex de Haan

RE: Consistent Null Handling

Other related posts: