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
- 9400 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
Explain vproc in teradata?
What are differences between teradata and ansi session modes in teradata?
What is the meaning of Caching in Teradata?
What are the available primary index types?
What are the functions of a Parser?
Explain the new features of teradata?
What are the updated features of teradata?
What does Amp contain and what are all the operations that it performs?
What are the different softwares used with their functions in teradata?
What is a sparse index?
Explain the term 'foreign key' related to relational database management system?
Explain teradata vs. Redshift?
What are normalization, first normal form, second normal form and third normal form?
Difference between multiload and tpump?
Difference between stored procedure and macro?
