1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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 / john

Answers were Sorted based on User's Feedback



whether Nulls will be counted while doing average? example: we have table column A with following v..

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.

Is This Answer Correct ?    11 Yes 0 No

whether Nulls will be counted while doing average? example: we have table column A with following v..

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

Is This Answer Correct ?    2 Yes 0 No

whether Nulls will be counted while doing average? example: we have table column A with following v..

Answer / tdguy

nulls will not be considered for averages.

Is This Answer Correct ?    1 Yes 0 No

whether Nulls will be counted while doing average? example: we have table column A with following v..

Answer / maka

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

Is This Answer Correct ?    2 Yes 2 No

whether Nulls will be counted while doing average? example: we have table column A with following v..

Answer / bkishor

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Teradata Interview Questions

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

0 Answers  

How to find duplicates in a table?

0 Answers  

What is the difference between teradata and oracle?

0 Answers  

Why AMP & PE are called Vprocs?

4 Answers  

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

0 Answers  




What does Amp contain and what are all the operations that it performs?

0 Answers  

Highlight the limitations of TPUMP Utility.

0 Answers  

Highlight the advantages of PPI(Partition Primary Index).

0 Answers  

Describe primary index in teradata?

0 Answers  

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  

What is the use of having index's on table?

1 Answers  

What is the process to restart the multiload if it fails?

7 Answers  

For more Teradata Interview Questions Click Here
Categories