It depends up on the which database we are using. I m using PostgreSQL it

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 / swapnil

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

Answer Posted / swapnil

It depends up on the which database we are using. I m using
PostgreSQL it is in open source.It returns 0 value.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a page in db2?

1019

What is the maximum size of varchar data type in db2?

1116

Is db2 a programming language?

1032

What is a storage group (stogroup)?

1234

What is db2 optimizer?

1217

What is access path in db2?

969

define clustering index.

1010

What is the difference between plan and package in db2?

1095

Explain db2.

1016

What is scrollable cursor in db2?

1042

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

4875

How to restart a DB2 program?

1879

What is runstats and reorg in db2?

1286

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2166

On which levels locks can be applied?

1111