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
10253 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

Explain teradata utilities. What is multiload, fast load, tpump?

1005

Write a program to show the parser component used in teradata?

969

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

1051

What are the functions involved in shared information architecture?

1070

What is teradata? What are some primary characteristics of teradata?

967

What is meant by Teradata Gateway?

1057

What is meant by a dispatcher?

1008

How do you verify a complicated sql?

1057

What is a node in teradata? Explain

1000

What is meant by a Channel Driver?

1233

What happens in a conflict? How do you handle that?

1042

What is primary index and secondary index?

1022

What is stored procedure in teradata?

1020

What are the different design perspectives used in teradata?

981

How do you define Teradata?

1029