Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10437 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / tdguy
nulls will not be considered for averages.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to Extract data from multiple legacy systems?
What is the difference between union and union all in teradata?
What are the various etl tools in the market?
Is multi insert ansi standard?
Explain some differences between mpp and smp?
Explain the term 'foreign key' related to relational database management system?
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 teradata? Also, list out some of the primary characteristics of teradata.
How do you set the session mode parameters in bteq?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Highlight the limitations of TPUMP Utility.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How do you determine the number of sessions?
what are the uses of fact table and dimension table in banking project?
What is meant by a Virtual Disk?
