NULL

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
16007 Views
Amdocs, I also Faced
E-Mail Answers

Answer Posted / guest

NULL

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dbrm library?

995

Differentiate between cs and rr isolation levels? Where do you specify them?

1020

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1089

What is a dbrm in db2?

965

How to check table size in db2 sap?

975

Mention the definition of cobol in varchar field.

1176

Define predicate?

1062

Is db2 free?

1035

List down the data types in the db2 database.

1038

What is bufferpool in db2?

983

What is schema in db2?

959

How many types of page locks can be held in db2?

991

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

What is a collection in db2?

978

What is the maximum number of columns in a db2 table?

1210