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
- 8955 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
Differentiate database data and data warehouse data?
What are the various indexes in teradata? How to use them?
Explain vproc in teradata?
How is MLOAD Teradata Server restarted after execution?
What can be achieved by using the teradata rdbms?
Steps to create a data model?
What are some primary characteristics of teradata?
What are tpump utility limitations?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the different softwares used with their functions in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What do you mean by teradata intelliflex?
Highlight the differences between Primary Key and Primary Index.
How many tables can you join in v2r5?
What exactly do you know about catching in teradata?
