Re: please help me ! I am hurry
From: <rtproffitt_at_my-deja.com>
Date: Mon, 15 Nov 1999 16:13:29 GMT
Message-ID: <80pbf4$71t$1_at_nnrp1.deja.com>
Date: Mon, 15 Nov 1999 16:13:29 GMT
Message-ID: <80pbf4$71t$1_at_nnrp1.deja.com>
Like Olivier states... this is the way these
functions work. Count, sum, average, all of them....
If you need to include data points which are null
(in other words, you are treating NULL as having a
meaning rather than it being "no data"),
then you may use the nvl function....
example, count(nvl(column, 0))
Remember, though, that the meaning of NULL is not the same as zero....
Robert Proffitt
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Nov 15 1999 - 17:13:29 CET