It depends up on the which database we are using. I m using PostgreSQL it

what will be the output of the below given query, if no
matching records are found : (a.) 0 (b.) null (c.) error

select Avg(salary)
from TableA
where Deptno = 'insurance'

Question Posted / swapnil

10 Answers
16022 Views
Amdocs, I also Faced
E-Mail Answers

Answer Posted / swapnil

It depends up on the which database we are using. I m using
PostgreSQL it is in open source.It returns 0 value.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is database manager in db2?

966

What is the maximum size of varchar data type in db2?

1065

List down the data types in the db2 database.

1040

What is declare cursor?

1042

Who uses db2?

981

What is sqlca’s maximum length?

1101

Explain about open switch business continuity software?

1072

Is db2 a database?

910

Which is faster delete or truncate?

1069

What is buffer pool in the db2 database?

1046

What are foreign keys in db2?

1033

What is the difference between nvl and coalesce?

1009

How do I create a view in db2?

973

How and when does the db2 enforces the unique key?

1028

What is the information associated with sysibm.syslinks table?

1055