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
16703 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 the difference between oracle and db2?

1173

What is db2 connect?

1125

What is check constraint. Explain with example.

1163

What is rct?

1290

What is load replace in db2?

1050

Before you give the explain statement, what are the prerogatives?

1082

What are the bind parameters ibm db2?

1102

What is runstats db2?

1077

What is netezza database?

1082

What is dpf in db2?

1168

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2116

What is role in db2?

1164

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1161

What is the usage of open cursor command?

1146

What are db2 objects?

1091