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?
- 5 Answers
- 9453 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
any one answer me how they can analyzing the project using data ware housing?
What tools would you use for that?
Explain teradata utilities?
Describe the set operators in teradata.
Explain amp in teradata?
What are the components provided on node?
What are the newly developed features of Teradata?
Explain the term 'row' related to relational database management system?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is basic teradata query language?
What are the different methods ot loading a dimension table? A fact table etc?
How you will check the version of teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Explain the parallel data extension in teradata?
What is smp and mpp platforms?
