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
- 10436 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rkraju
while doing average nulls value cannot considered
>>in that above example 4 values is there but while
caluculating average it consider only 3 values y becz in
that four values one values is there so the o/p is
>> 5+null+8+3=16/3
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the components provided on node?
Highlight the limitations of TPUMP Utility.
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
How you will check the version of teradata?
Write a program to show the parser component used in teradata?
What is the purpose of using case expression in teradata?
Explain the parallel data extension in teradata?
What is spool space?
What are teradata utilities?
List out all forms of LOCKS that are available in Teradata.
What are the different design perspectives used in teradata?
What are the different softwares used with their functions in teradata?
What is meant by a node?
While creating table my dba has fallback or no fallback in his ddl. What is that?
