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>


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

Original text of this message