Nulls are ignored in AVg Function.so the output will be 5+8+3/3

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?

Question Posted / bkishor

5 Answers
10113 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / bkishor

Nulls are ignored in AVg Function.so the output will be 5+8+3/3

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is bteq script in teradata?

1100

What are the joins in teradata?

941

What is the use of stored procedures in teradata?

953

Highlight a few of the advantages that ETL tools have over Teradata.

1046

Explain the term 'tables' related to relational database management system?

994

What are the uses of bynets in multi-node systems?

982

Explain the term 'primary key' related to relational database management system?

1001

List out all forms of LOCKS that are available in Teradata.

933

What is the purpose of using case expression in teradata?

972

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1111

What is real time and near real time data warehousing?

1078

how can we analyze the locks ?

2077

What are the different table types supported by teradata?

910

How is the teradata different from oracle?

1052

Explain some differences between mpp and smp?

1052