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

What do you mean by teradata sql assistant?

0 Answers  

What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,

What are the joins in teradata?

0 Answers  

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

0 Answers  

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

6 Answers   Satyam,

What is bteq utility in teradata?

0 Answers  

What are the functions performed by bynet?

0 Answers  

What are the newly developed features of Teradata?

0 Answers  

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,

Explain the term 'foreign key' related to relational database management system?

0 Answers  

1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,

wt r before journal& after journel.....in teradata

4 Answers