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
- 8578 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the advantages of partitioned primary index in a query?
What do you mean by teradata sql assistant?
What is meant by a Least Cost Plan?
What is stored procedure in teradata?
What is the difference between global temporary tables and volatile temporary tables?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Describe primary index in teradata. And what are the available primary index types?
What is bteq script in teradata?
How many types of joins are there in teradata?
Can we collect statistics on multiple columns?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are default access rights in teradata? What explicit right can be given to a user?
What do high confidence, low confidence and no confidence mean in explain plan?
What is a dimension table?
What is the purpose of joins in teradata and what are the available join types?
