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

What is the physical storage length of the data types date, time, and timestamp?

1095

What is image copy in db2?

1024

How to check sequence on a table in db2?

1070

What is isolation level in db2?

1018

What is rct?

1245

How does cobol compile db2 program?

1081

Define check constraint.

1085

Give the name of some fields form sqlca.

1093

How can you quickly find out the # of rows updated after an update statement?

1054

What is a db2 package?

1071

What is the information associated with sysibm.syslinks table?

1132

What is null indicator in cobol db2?

1073

What is bind plan?

1059

What is ibm db2 database?

1017

How can the duplicate values be eliminated from db2 select?

1111