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
- 10130 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 primary key and partition key?
List out some of the primary characteristics of teradata.
What are the different functions included in the server software?
What is the difference between fastload and multiload? Which one is faster?
Explain some differences between mpp and smp?
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 design features involved in teradata?
How can bottlenecks be identified?
What are the newly developed features of Teradata?
what is sysdba and sysdbc ? which has high priority ?
What do you mean by tpt in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
Comment whether bottleneck is an error or not.
If a Node is busy what are the steps you can take to avoid ?
Syntax for case when statement?
