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
- 13442 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 null indicator in db2?
What does reorg do in db2?
What language is db2 written in?
What r the comman abends in db2, jcl and cobol???????
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the difference between nvl and coalesce?
what is utility for parm lib
Why db2 is called db2?
What is meant by explain?
Explain about cursor stability?
What is dbrm library?
What is the use of dclgen in db2?
What is the use of predicate?
What is dbrm?
How do I connect my db2 database to ibm?
