ANSWER IS B. IT GIVES NULL.

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

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

Answer Posted / varalakshmi

ANSWER IS B. IT GIVES NULL.

Is This Answer Correct ?

20 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How connect db2 database to datastage?

1203

What is schema in db2?

981

What are union and union all?

951

What are db2 objects?

1016

What is dbrm? When it will be created?

988

What are the rules for db2 programming?

1058

What action db2 takes when a program aborts in the middle of a transaction?

1117

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

1199

What is the difference between bind and rebind in db2?

1417

How would the varchar column remarks defined?

1049

Can we delete records from view?

934

How can you do the explain of a dynamic sql statement?

1041

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2884

What does db2 mean?

972

What is the purpose of rollback and commit?

1125