It will be error, as we are using where with AVG function....we should use

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

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

Answer Posted / shailendra

It will be error, as we are using where with AVG function....we should use having

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can the duplicate values be eliminated from db2 select?

1106

If I have a view which is a join of two or more tables, can this view be updateable?

1139

What is runstats and reorg in db2?

1305

What is a trigger in the db2 database?

1084

Explain packages.

1114

What is the role of the data page in the db2 database?

1028

What is isolation level in db2?

1006

What are concurrency issues?

1097

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1240

Discuss about db2 bind?

1098

What is table space in db2?

1019

What is dbrm in db2 database?

1118

What parameters are used to control the free space in DB2?

1057

What is the advantage in De-normalizing tables in DB2?

1181

What is coalesce in db2?

1136