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 / tdguy
nulls will not be considered for averages.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between union and union all in teradata?
Explain the term 'foreign key' related to relational database management system?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Highlight the limitations of TPUMP Utility.
Which is faster fastload or multiload?
Describe the set operators in teradata.
What are some primary characteristics of teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is the use of teradata system software?
Why is the case expression used in teradata?
What is a level of granularity of a fact table?
Explain amp in teradata?
What exactly do you know about catching in teradata?
what is object level locking ? where do appear this type of locking ?
How do you verify a complicated sql?