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
10223 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 the maximum number of dml can be coded in a multiload script?

1089

Explain how spool space is used.

1060

Explain BYNET.

984

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

4359

What is the command in bteq to check for session settings ?

1168

Explain fastload in teradata?

1087

What is collect statistics?

980

What is stored procedure in teradata?

1004

If RDBMS is halted what will you do ?

2143

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1762

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

1023

What is TPD?

1356

Explain the meaning of Amp?

1116

What are the primary characteristics of the Teradata.

1124

What are the steps to create a data model?

1029