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
16019 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 is the syntax for creating a table in the db2 database?

1057

What is db2 instance?

1015

What is database alias db2?

1065

What is cursor in dbms?

1005

Is schema the same as database?

1005

What is load replace in db2?

935

What's The Percentage Free Space ?

1157

What is null in db2?

947

What is data manager?

993

Which command is used to remove all rows from a table?

1037

Mention the different locking levels that are available in db2.

1069

What are union and union all?

920

How to create backup table in db2?

1041

Give the name of some fields form sqlca.

1021

What is the clustering index in the db2 database?

955