Re: NVL

From: takesiro <takesiro_at_coral.ocn.ne.jp>
Date: Sun, 7 May 2006 13:51:07 +0900
Message-ID: <e3juc6$tgm$1@news-est.ocn.ad.jp>

There are completely different.

SUM()function is always ignoring NULL value. So If data are following
user: value
A 200
B
C 100

sum(nvl(col,0)) = 100
nvl(sum(col,0)) = may be ERR
nvl(sum(col),0) = 150

"J Huntey Palmer" <jhp_at_dontspam.spam> wrote in message news:125qsn7f41fk61a_at_news.supernews.com...
> WHat is the difference between sum(nvl(col1,0)) and nvl(sum(col,0)) and
> nvl(sum(nvl(col9,0)))?
>
> Which is the best to use to ensure that there are no snafus?
>
> Thanks
Received on Sat May 06 2006 - 23:51:07 CDT