Lalit, I contradict your answe because the question itself says that ther

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 / guest.

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

Answer Posted / guest.

Lalit, I contradict your answe because the question itself
says that there is no matching record with
deptno='insurance'. So (b)is the correct answer.

Is This Answer Correct ?

20 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what are the various isolation levels possible?

988

What are packages in db2?

969

What is the difference between spufi and qmf?

1052

What is the difference between db2 and oracle?

1067

How do you select a row using indexes in db2?

1072

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

1180

What is the use of commit in db2?

1000

is it compulsory commitment control in journal?

2413

what is utility for parm lib

2308

How and when does the db2 enforces the unique key?

1028

What is cobol db2?

930

What does db2 mean?

954

How do I add a column in db2?

997

How to check last update on table in db2?

999

Explain about mirror activator disk mirroring?

953