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
16033 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 database reorganization?

1056

Give a brief description of db2 isolation levels?

1014

How many databases can be created inside an instance in db2 ?

981

What is bind package and plan in db2?

1006

Explain db2.

993

How to compare data between two tables in db2?

1033

What is the latest version of ibm db2?

1203

What is the syntax for seeing the columns and data types of a table in the db2 database?

1089

How to find the number of rows in db2 tables?

999

What is the role of data manager in the db2 database?

1053

Which are the db2 tools to protect integrity of the database?

1073

What kind of database is db2?

977

What are the different types of base tables?

1029

What is difference between alias and synonym in db2?

1072

What are packages in db2?

972