get null from sum () if a null value exists
658593Mar 9 2009 — edited Mar 9 2009Hello to everybody,
does anyone know a trick to get NULL from the sum() function if one of the values is NULL.
E.g.
Take table 'TEST'
select * from test
NO
-----
1
19
4 rows selected.
select sum(no) from test;
SUM(NO)
-----
20
1 row selected.
Is there a possibilty to get NULL as result?
Uwe
Edited by: GrumbleDuke on 09.03.2009 15:36
Edited by: GrumbleDuke on 09.03.2009 15:40