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
16298 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 are the rules for db2 programming?

1071

What is load utility in db2?

1167

What is a cursor in programming?

1047

What is clone table?

1029

What is consistency token in db2?

1114

How to resolve deadlock issue

20054

List out the buffer pools in db2

1060

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

1081

What is db2 plan table?

1025

Mention the definition of cobol in varchar field.

1227

What is host variable in db2 cobol?

1057

Is db2 relational database?

962

What is temporal table in db2?

1021

If I have a view which is a join of two or more tables, can this view be updateable?

1128

What is cursor in dbms?

1048