answer is (a.) 0 0 recod selected.

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

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

Answer Posted / vinay

answer is

(a.) 0

0 recod selected.

Is This Answer Correct ?

7 Yes

19 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11690

Is db2 a mainframe database?

1007

How to retrieve rows from a db2 table in embedded sql?

1400

What are the benefits of using the db2 database?

1240

On which levels locks can be applied?

1145

What is the use of value function?

1160

What is explain in db2?

1039

Define sqlca.

1119

Describe major components of db2?

1100

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1054

What is consistency token in db2?

1154

What are the various data types available in db2?

1103

How do I create a view in db2?

1029

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

1153

What is page size in db2?

986