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

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

9 Answers   IBM,

What are the available join types in teradata?

0 Answers  

In Teradata, how do we Generate Sequence?

0 Answers  

What are the 5 phases in a multiload utility?

0 Answers  

Difference between star and snowflake schemas?

0 Answers  

How to cast date "2015-03-03-012204-000000" to timestamp

1 Answers   Cognizant,

What are the commands to make a new table, change a table and remove a table in teradata?

0 Answers  

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.

2 Answers  

What is meant by Teradata Gateway?

0 Answers  

What is collect State in Teradata ? what it use and how it works??

3 Answers   TCS,

What is dimensional modeling?

0 Answers  

For more Teradata Interview Questions Click Here
Categories