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
16365 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 db2?

1172

How can you quickly find out the # of rows updated after an update statement?

1036

What is node in db2?

1040

Explain correlated sub-queries.

1025

Is the primary key a clustered index?

1138

What is the default page size of buffer pools?

1120

How to find the maximum value in a column in the db2 database?

1069

Define db2.

1104

What is table space in db2?

1014

Give the name of some fields form sqlca.

1068

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

1143

Explain various types of locks in db2?

1136

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8273

What is sqlca?

1061

What is bind in db2?

1034