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

List down the types of triggers in the db2 database?

962

How do I create a view in db2?

969

Explain about mirror activator disk mirroring?

953

How do I copy a table in db2?

950

How many databases are there?

989

What are db2 objects?

999

What is sqlca’s maximum length?

1098

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

1322

What is a bind card?

1140

How do you select a row using indexes in db2?

1072

What is nvl in db2?

1039

What is commit in db2?

995

Which are the db2 tools to protect integrity of the database?

1070

What is ibm db2 connect?

927

What is explain plan in db2?

940