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 / maka
Null value can not be counted with aggregate functions.
count(*) count null.
Here result will be 5
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to load specific no.of records using bteq, or fastload,or multiload
Can we collect statistics on multiple columns?
What do you mean by ttu in teradata?
What are the available primary index types in teradata.
What is the use of teradata system software?
What do you mean by fastexport in teradata?
What is basic teradata query language?
What are some primary characteristics of teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
what are the day to day activities of teradata DBA ?
What is a three-tier data warehouse?
Explain the parallel data extension in teradata?
Explain the new features of teradata?
What are the uses of bynets in multi-node systems?
How to select first n records in teradata?