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
Explain the meaning of Amp?
What happens in a conflict? How do you handle that?
What are aggregate tables? How do you design them using teradata?
What is real time and near real time data warehousing?
What is the use of having index on table?
What is the use of fallback?
what is sysdba and sysdbc ? which has high priority ?
What are the things to be considered while creating secondary index?
How many sessions of MAX is PE capable of handling at a particular time?
Explain parsing engine in teradata?
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 do you mean by fastexport in teradata?
How is MLOAD Teradata Server restarted after execution?
What do high confidence, low confidence and no confidence mean in explain plan?
How is the teradata different from oracle?