Reg: Query about null value addition in a sql query

muthukannan · New User Joined: 03 Aug 2006 Posts: 42 Location: Chennai

Hi,

While adding a values in a sql query will the null values are considered or will it be omitted?

Eg.

col1 col2
----- ------
1 1
1 2
1
1 3
1 4

if we try adding the col2 using group by col1 will the null value of col2 will be considered?

Please advice...

Thanks in advance...

Thanks,
Mk

dbzTHEdinosauer · Posted: Thu Sep 06, 2007 11:26 am

Do you mean add or the column function SUM?

muthukannan · New User Joined: 03 Aug 2006 Posts: 42 Location: Chennai

Hi,

I have mentioned about SUM only.

Thanks,
Mk

Help-Me-Out · New User Joined: 09 Dec 2006 Posts: 56 Location: Pune

Hi,

It will give data type or length error. it will never do like this.

Atleast zero should be present in that.