while doing average nulls value cannot considered >>in that above ex

whether Nulls will be counted while doing average?
example: we have table column A with following values
A
--
5
Null
8
3

Now what is the average of A?

Question Posted / rkraju

5 Answers
10245 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / 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

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between global temporary tables and volatile temporary tables?

1164

What are default access rights in teradata?

1109

Explain fastload in teradata?

1094

What do you mean by fastexport in teradata?

993

What do you mean by ttu in teradata?

1031

How to run a query in teradata?

1062

What is a clique?

1080

What are aggregate tables? How do you design them using teradata?

1162

Explain BYNET.

987

How do you verify a complicated sql?

1055

Write a program to show the parser component used in teradata?

968

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3369

What is the primary index in teradata?

1191

What exactly do you know about catching in teradata?

1034

How would you load a very large file in teradata in general?

1028