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
- 10287 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.
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is the difference between fastload and multiload?
How is MLOAD Client System restarted after execution?
Comment whether bottleneck is an error or not.
How do you determine the number of sessions?
What do you mean by parsing?
Highlight a few of the advantages that ETL tools have over Teradata.
How to view every column and the columns contained in indexes in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What do you mean by teradata intelliflex?
What are tpump utility limitations?
How many tables can you join in v2r5?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the opening step in basic teradata query script?
