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

A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 Answers  

What are the scenarios in which full table scans occurs?

0 Answers  

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

0 Answers  

When tpump is used instead of multiload?

0 Answers  

If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?

1 Answers   Teradata,




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

7 Answers  

What is the command in bteq to check for session settings ?

0 Answers  

why use references rather than pointers in the public api, particularly for arguments which are modified?

0 Answers  

What are the various reporting tools in the market?

0 Answers  

Explain teradata architecture?

0 Answers  

Why does varchar occupy 2 extra bytes?

0 Answers  

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

For more Teradata Interview Questions Click Here
Categories