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
16169 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

What are the bind parameters ibm db2?

1009

What is precompiler in db2?

984

Why do we bind in db2?

1169

How many databases are there?

1022

Define db2 and its databases?

1029

What is db2 stogroup?

1124

Why do we use cursor?

1072

What is lock escalation in db2?

986

What is db2 bind process?

1202

What is db2? Explain.

1000

What is db2 bind?

1035

What is the clustering index in the db2 database?

970

Is schema the same as database?

1027

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1124

What is a db2 table?

978