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 the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  

Diff b/w v2r5 and v2r6 ?

3 Answers   TCS,

i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.

1 Answers  

Define views in teradata with syntax.

0 Answers  

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,




Explain how spool space is used.

0 Answers  

How to run a query in teradata?

0 Answers  

How do you determine the number of sessions?

0 Answers  

What is logical data model?

0 Answers  

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

any one pls tell me what are the table names in banking project?

2 Answers  

can we load 10 millions of records into target table by using tpump?

1 Answers   HP,

For more Teradata Interview Questions Click Here
Categories