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 are the uses of bynets in multi-node systems?
List out all forms of LOCKS that are available in Teradata.
What is primary index and secondary index?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Explain teradata vs. Redshift?
What is meant by a Channel Driver?
Explain vproc in teradata?
How to select first n records in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the components used in smp and massively parallel processing (mpp) machines?
Explain the term 'columns' related to relational database management system?
what are the uses of fact table and dimension table in banking project?
What are some primary characteristics of teradata?
Differentiate database data and data warehouse data?
What does sleep function does in fast load?