ans is a) ZERO the anser is ZERO because there is no record in the table

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

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

Answer Posted / pankaj

ans is a) ZERO

the anser is ZERO because there is no record in the table
they can shows the zero value present in the table

0 record is selected

message is disply

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to compare data between two tables in db2?

1088

How to run db2 command in windows?

1193

On which levels locks can be applied?

1133

What are types of indexes?

1074

what is the sqlcode -501

13152

Explain about mirror activator disk mirroring?

1011

What is db2 connect?

1070

What is dclgen in db2?

1149

How to execute stored procedures?

1130

What is a storage group (stogroup)?

1246

What is ibm db2 connect?

999

Mention the various locks that are available in db2.

1039

How do I connect my db2 database to ibm?

1051

What's The Percentage Free Space ?

1224

What is a db2 package?

1058