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
16398 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 meant by union and union all?

1012

What is netezza database?

1028

What is declare cursor?

1123

What is database alias db2?

1127

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 ?

2181

What is catalog database in db2?

1165

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

What is the physical storage length of timestamp data type?

1095

What is the use of db2 optimizer?

1117

What is the difference between cursor stability and repeatable read isolation levels?

1175

What is the maximum length of sqlca?

1529

What is a cursor in programming?

1069

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

1068

How and when does the db2 enforces the unique key?

1083

What language is db2 written in?

1049