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 / bkishor
Nulls are ignored in AVg Function.so the output will be 5+8+3/3
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the functions involved in shared information architecture?
What is dimensional modeling?
Is multi insert ansi standard?
What are some primary characteristics of teradata?
What are the various indexes in teradata? How to use them?
What is the basic syntax for teradata select statement?
What are some commonly used bteq scripts?
If RDBMS is halted what will you do ?
What can be achieved by using the teradata rdbms?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is a dimension table?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are types of partition primary index (ppi) in teradata?
What are the functions of a Parser?
What is the primary index in teradata?