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
- 8573 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
Difference between stored procedure and macro?
What are some primary characteristics of teradata?
What are the various indexes in teradata?
What are the functions of a Parser?
What do high confidence, low confidence and no confidence mean in explain plan?
Can you fastexport a field, which is primary key by putting equality on that key?
What is multi insert?
Define views in teradata with syntax.
Explain how spool space is used.
What are the commands to make a new table, change a table and remove a table in teradata?
What is bteq script in teradata?
Highlight all the modes that are present under Confidence Level.
What is the multi-insert?
Explain some differences between mpp and smp?
What are the various indexes in teradata? Why are they preferred?
