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
- 13444 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / vinay
answer is
(a.) 0
0 recod selected.
| Is This Answer Correct ? | 7 Yes | 19 No |
Post New Answer View All Answers
Explain what are the various isolation levels possible?
Is schema the same as database?
What does db2 stand for?
What is difference between alias and synonym in db2?
What is the maximum length of sqlca?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to resolve deadlock issue
What is cobol db2?
How do I add a column to an existing table in db2?
What language is db2 written in?
What are the full forms of spufi and dclgen and why are they used?
What is db2 look?
How can the duplicate values be eliminated from db2 select?
What is the latest version of ibm db2?
What is syscat in db2?
