Answer / yuvaevergreen

yes..as said above, nulls would be completely ignored while
calculating averages.
similarly, while counting that column alone, "sel count(a)"
will give you 3 ignoring null.

Answer / rkraju

while doing average nulls value cannot considered
>>in that above example 4 values is there but while
caluculating average it consider only 3 values y becz in
that four values one values is there so the o/p is
>> 5+null+8+3=16/3

Answer / tdguy

nulls will not be considered for averages.

Answer / maka

Null value can not be counted with aggregate functions.
count(*) count null.
Here result will be 5

Answer / bkishor

Nulls are ignored in AVg Function.so the output will be 5+8+3/3

How is MLOAD Client System restarted after execution?

0 Answers  

why varchar takes 2 extra bytes?

4 Answers   IBM,

How to eliminate product joins in a teradata sql query?

0 Answers  

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

0 Answers  

What is the purpose of indexes?

0 Answers  

How can you track login parameters of users in teradata?

0 Answers  

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,

Explain about Skew Factor?

6 Answers   TCS,

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

What are the steps involved after the disk manager passes the request?

0 Answers  

In general, how do you optimze any sql in teradata?

0 Answers  

The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,