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
- 9287 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
How do you define Teradata?
What is meant by a dispatcher?
What are aggregate tables? How do you design them using teradata?
In BTEQ, how are the session-mode parameters being set?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are the functions of a Parser?
How you will check the version of teradata?
What is the difference between global temporary tables and volatile temporary tables?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What do you mean by tpt in teradata?
What are types of partition primary index (ppi) in teradata?
What is the purpose of joins in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Explain the parallel data extension in teradata?
