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 a node in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is the difference between teradata and oracle?
Explain the parallel data extension in teradata?
What is the opening step in basic teradata query script?
What is bteq script in teradata?
When tpump is used instead of multiload?
What is database exceptions in teradata?
Describe primary index in teradata?
Differentiate database data and data warehouse data?
Why do you get spool space errors? How do trouble-shoot them?
What exactly do you know about catching in teradata?
Where is teradata rdbms used?
What are the various reporting tools in the market?