Interested to Buy Any Domain ? << Click Here >> for more details...
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'
- 10 Answers
- 16166 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
What does db2 stand for?
What is the meaning concurrency in the db2 database?
What is the difference between dbm cfg and db cfg file in db2 ?
How do I create a view in db2?
When the like statement is used?
What is an instance in db2?
What is the difference between oracle and db2?
What is dbrm? What it contains? When it will be created?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is an instance database?
Explain packages.
What is dbrm? What it contains?
What is a plan and package in db2?
Before you give the explain statement, what are the prerogatives?
What is the usage of open cursor command?
