Sign Up Login


  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

What are some primary characteristics of teradata?

0 Answers  

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

0 Answers  

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

0 Answers  

What is database exceptions in teradata?

0 Answers  

What do you mean by parsing?

0 Answers  




What is stored procedure in teradata?

0 Answers  

How do you load Multiple files to a table by using fastload scripts?

1 Answers   Satyam,

Discuss the advantages of using partitioned primary index in a query?

0 Answers  

what are the roles and responsibilities of teradata DBA ?

1 Answers   TCS,

Explain the most common data types used in teradata?

0 Answers  

can i call router is a passive transformation

2 Answers  

What are the multiload utility limitations?

0 Answers  

For more Teradata Interview Questions Click Here
Categories