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
- 9295 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
What happens in a conflict? How do you handle that?
What is the purpose of indexes?
what is sysdba and sysdbc ? which has high priority ?
What are the various reporting tools in the market?
During the Display time, how is the sequence generated by Teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the various etl tools in the market?
List out some of the primary characteristics of teradata.
What happens when a node suffers a downfall?
What is real time and near real time data warehousing?
What is the function of parser component in teradata?
Mention a few of the ETL tools that come under Teradata.
Explain fallback in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
