Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10222 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
What is meant by a Parsing Engine?
Explain how spool space is used.
What is oltp?
What are default access rights in teradata?
What do you mean by parsing?
What are aggregate tables? How do you design them using teradata?
What is the purpose of using case expression in teradata?
What is the multi-insert?
What is teradata? What are some primary characteristics of teradata?
Steps to create a data model?
Why are oltp database designs not generally a good idea for a data warehouse?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the available primary index types in teradata.
In the Primary Index, what is the score of AMPs that are actively involved?
