Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: NULL and Aggregate Functions
On Feb 6, 12:23 am, "klabu" <klab..._at_gmail.com> wrote:
> I don't remember but....
>
> if some_column has NULL, SUM(some_column) will be NULL ?\
>
> Is this true in 8i..?
If you are uncertain, set up a test to determine the correct answer: CREATE TABLE T1 (TA VARCHAR2(10), TN NUMBER(10));
INSERT INTO T1 VALUES ('TEST',1); INSERT INTO T1 VALUES ('TEST2',2); INSERT INTO T1 VALUES ('TEST3',3); INSERT INTO T1 VALUES ('TEST4',NULL); INSERT INTO T1 VALUES ('TEST5',NULL);
SELECT
SUM(TN), MIN(TN), MAX(TN),
SUM(TN) MIN(TN) MAX(TN) COUNT(TN)
6 1 3 3
SELECT
SUM(TN), MIN(TN), MAX(TN),
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Tue Feb 06 2007 - 05:51:37 CST
![]() |
![]() |