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
- 10313 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
What happens in a conflict? How do you handle that?
How many types of joins are there in teradata?
What is partitioned primary index (ppi)?
Explain parsing engine in teradata?
Highlight the advantages of PPI(Partition Primary Index).
What is dimensional modeling?
What are the various indexes in teradata? How to use them?
List the logical and conditional operators that are used with teradata along with their meanings?
What is the opening step in basic teradata query script?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Why teradata is used?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Differentiate database data and data warehouse data?
What is TPD?
How do you see a ddl for an existing table?
