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
16434 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

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1093

What is a system catalog table in db2?

1192

Can we update view in db2?

1007

What is universal database?

1074

When reorg is used?

1138

What is a storage group (stogroup)?

1250

How do I start db2 in windows?

1104

Explain the benefits you can get from mainframe connect?

975

What is db2 connect?

1081

What is db2 purescale?

1012

What is cascading rollback?

1220

When do you specify the isolation level?

1040

What is db2 look?

1032

Is the primary key a clustered index?

1153

How to get the ddl of a table in db2?

1134