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
10283 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

Describe primary index in teradata. And what are the available primary index types?

1004

What are tpump utility limitations?

1118

What is the purpose of indexes?

1074

Where is teradata rdbms used?

1097

What do you mean by teradata sql assistant?

1062

What is the difference between teradata and oracle?

1027

What is the difference between union and union all in teradata?

1128

What is the use of fallback?

996

Explain PDE.

1080

What is the purpose of joins in teradata and what are the available join types?

1086

What are the various indexes in teradata? Why are they preferred?

1006

Explain the term 'tables' related to relational database management system?

1048

How to view every column and the columns contained in indexes in teradata?

1056

Did you write stored procedures in teradata?

1132

Highlight a few of the advantages that ETL tools have over Teradata.

1090