> When you do average of a column that includes null values, does it ignore
> the rows with null or does it not ?

> If it does not, how can we include it
> ..i mean if we have 5 rows with one null value, how can we avg with 4 and
> also average with 5.. Thanks

"Hassan" <fatima_ja@hotmail.com> wrote in message
news:OoktTZb2EHA.2568@TK2MSFTNGP10.phx.gbl...
> When you do average of a column that includes null values, does it ignore
> the rows with null or does it not ? If it does not, how can we include it
> ..i mean if we have 5 rows with one null value, how can we avg with 4 and
> also average with 5.. Thanks
>
>

"Ed" <Ed@discussions.microsoft.com> wrote in message
news:32005B20-E174-46B7-B9D5-6AB4BB578C27@microsoft.com...
>
> Here you go
> avg with 4: -- ignore null
> Select avg(ColummName) from TableName
>
> avg with 5: -- include null
> select avg(a.b) from (select case when ColumnName is null then 0 else
> ColumnName end as b from TableName) a
>
> Good luck
>
> Ed
>
>
>
>
> "Hassan" wrote:
>
>> When you do average of a column that includes null values, does it ignore
>> the rows with null or does it not ? If it does not, how can we include it
>> ...i mean if we have 5 rows with one null value, how can we avg with 4
>> and
>> also average with 5.. Thanks
>>
>>
>>