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
- 10221 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / bkishor
Nulls are ignored in AVg Function.so the output will be 5+8+3/3
| Is This Answer Correct ? | 0 Yes | 0 No |
Describe primary index in teradata. And what are the available primary index types?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
Difference between multiload and tpump?
What are the advantages of teradata?
What is collect statistics?
What is the purpose of using case expression in teradata?
What is Join Index in TD and How it works?
How to relege locks in fastload and multiload? example?
Why are oltp database designs not generally a good idea for a data warehouse?
Explain fastload in teradata?
Teradata 
