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
- 16296 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
is it compulsory commitment control in journal?
When the like statement is used?
What is access path in db2?
Which isolation level provides maximum concurrency?
What is database manager in db2?
What does runstats do in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What os does db2 run on?
How many databases are there?
What is difference between isnull and coalesce?
Explain about open switch business continuity software?
List out the buffer pools in db2
What is page size in db2?
What do you mean by storage group (stogroup)?
What is syscat in db2?
