error +100 we will get, record not found.......

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 / mr.perfect

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

Answer Posted / mr.perfect

error +100 we will get, record not found.......

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I import data from excel to db2?

1129

What do you mean by storage group (stogroup)?

1083

What is package in cobol db2?

1163

What is the use of with ur in db2?

1109

What is difference between isnull and coalesce?

1107

What is the use of db2 optimizer?

1175

How do you eliminate duplicate values in db2?

1269

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4372

What is data manager?

1104

What is the syntax for FETCH in DB2 ?

1268

Is db2 a database?

1028

What does reorg do in db2?

1075

When do you specify the isolation level?

1073

What are packages in db2?

1076

What is with ur in db2?

1384