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
- 10446 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 |
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
what is differences between Fastload and Multiload as per DBA aspect ?
How do you see a ddl for an existing table?
Highlight the need for Performance Tuning.
What tools would you use for that?
How do you determine the number of sessions?
Why Fload doesn’t support multiset table?
What is the use of having index on table?
Explain Teradata performance tuning and optimization?
What is SQL Assistence?please eample
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
How to run a query in teradata?
Teradata 
