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?
Answer Posted / tdguy
nulls will not be considered for averages.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between fastload and multiload?
Explain the term 'row' related to relational database management system?
Can we collect statistics on multiple columns?
What is the use of teradata system software?
What is a sparse index?
Why is the case expression used in teradata?
What are the advantages of teradata?
How many types of joins are there in teradata?
What are the newly developed features of Teradata?
Different phases of multiload?
what is sysdba and sysdbc ? which has high priority ?
What is bteq script in teradata?
What is real time and near real time data warehousing?
What is the difference between global temporary tables and volatile temporary tables?
How do you create tables? Exact syntax, and create profiles, users in teradata?