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
- 13537 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
What is explain plan in db2?
What is iseries database?
What is data manager?
What is schema in db2?
What db2 400?
Comment whether the cursor is closed during commit or not.
List out the buffer pools in db2
List down the data types in the db2 database.
What is the use of value function?
How do I copy a table in db2?
What is cursor stability in db2?
What is a db2 cursor?
What is the role of union all and union
What is the difference between oracle and db2?
What is the function of logging in the db2 database?
