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
16704 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 the syntax for seeing the columns and data types of a table in the db2 database?

1237

What is with ur in db2?

1384

Is db2 free?

1142

What is buffer pool?

1160

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2268

Explain about rct in db2?

1164

What is universal database?

1119

What is a collection in db2?

1094

How do I copy a table in db2?

1058

What is db2 and what is the use of db2 optimizer?

1111

What is a Foreign Key?

1140

How do I delete a table in database?

1079

Define sqlca.

1173

Which component is used to execute the sql statements?

1147

What is cursor with hold option in db2?

1138