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

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 Answers   IBM,

What do you mean by teradata sql assistant?

0 Answers  

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

6 Answers   Satyam,

How do you verify a complicated sql?

0 Answers  

What are the components used in smp and massively parallel processing (mpp) machines?

0 Answers  




What is Join Index in TD and How it works?

6 Answers   BT, CSC, TCS,

How do you see a ddl for an existing table?

0 Answers  

Highlight all the modes that are present under Confidence Level.

0 Answers  

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  

What are the main components of teradata system?

0 Answers  

What are the frequently used data types in teradata?

0 Answers  

How do you do backup and recovery in teradata?

0 Answers  

For more Teradata Interview Questions Click Here
Categories