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?
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 advantages of teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Why is the case expression used in teradata?
How to eliminate product joins in a teradata sql query?
What is the difference between teradata and basic rdbms?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the different functions performed in development phase?
What is meant by a dispatcher?
What is meant by a Highest Cost Plan?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain parsing engine in teradata?
What are the functions involved in shared information architecture?
What is stored procedure in teradata?
Highlight the limitations of TPUMP Utility.
What are the updated features of teradata?