ANSWER IS B. IT GIVES 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 / varalakshmi

10 Answers
16697 Views
Amdocs, I also Faced
E-Mail Answers

Answer Posted / varalakshmi

ANSWER IS B. IT GIVES NULL.

Is This Answer Correct ?

20 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is universal database?

1118

what is diffrence b/w file-aid tool and file-aid utility???

4959

How does db2 sample database connect?

1082

How many databases are there?

1111

How to rename a table in DB2 ?

1145

What is the use of commit in db2?

1140

What are the prerogatives?

1129

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

1138

What is the maximum No of rows per page?

1113

What is the role of schema in the db2 database?

1360

Define db2 and its databases?

1112

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3009

What is the difference between dbm cfg and db cfg file in db2 ?

1591

How to resolve deadlock issue

20318

What is query_cache_limit?

1036