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
- 9351 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / maka
Null value can not be counted with aggregate functions.
count(*) count null.
Here result will be 5
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Define views in teradata with general syntax.
What is the difference between fastload and multiload? Which one is faster?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What tools would you use for that?
Mention a few of the ETL tools that come under Teradata.
Highlight the limitations of TPUMP Utility.
How to identify ppi columns?
Explain Teradata performance tuning and optimization?
What is teradata? What are some primary characteristics of teradata?
What are the various reporting tools in the market?
What do you mean by parsing?
What are the newly developed features of Teradata?
What is meant by a Clique?
What are teradata utilities?
Can you fastexport a field, which is primary key by putting equality on that key?
