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
How to select first n records in teradata?
What is the difference between fastload and multiload? Which one is faster?
Can we collect statistics on table level?
How to load specific no.of records using bteq, or fastload,or multiload
How to find duplicates in a table?
How can you track login parameters of users in teradata?
What is the use of having index on table?
Syntax for case when statement?
What is partitioned primary index (ppi)?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is meant by a Channel Driver?
What is spool space?
What are the functions of a Parser?
Explain BYNET.
How many types of joins are there in teradata?