b if no matching records found then it will return null value

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 / rama krishna reddy

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

Answer Posted / rama krishna reddy

b

if no matching records found then it will return null value

Is This Answer Correct ?

36 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about rct in db2?

1101

What does db2 blu stand for?

1157

What is the difference between nvl and coalesce?

1057

How to retrieve rows from a db2 table in embedded sql?

1380

Can you tell me how can you find out the # of rows updated after an update statement?

1095

What are the contents of dclgen?

1101

What is consistency token in db2?

1133

List out the buffer pools in db2

1070

What is image copy in db2?

1006

What is db2?

1172

List out the three types of page locks that can be held.

1145

What is dclgen in db2?

1137

What does db2 plan contain?

1014

What are db2 objects?

1042

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1074