Null value can not be counted with aggregate functions. count(*) count nul

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 / maka

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

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

Please Help Members By Posting Answers For Below Questions

What do you mean by teradata intellicloud?

1074

What are the advantages of teradata?

1057

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4421

How does hashing happens in teradata?

1144

Difference between inner join and outer join?

1079

What is smp and mpp platforms?

1031

What are the available primary index types?

1272

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2240

Syntax for case when statement?

1113

How many sessions of MAX is PE capable of handling at a particular time?

1133

What is meant by a Highest Cost Plan?

1109

What is a clique?

1152

What are the components used in smp and massively parallel processing (mpp) machines?

1093

Highlight the need for Performance Tuning.

1152

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

1109