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
- 13530 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / guest
NULL
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Explain dclgen.
How does a cursor work?
Explain correlated sub-queries.
What is ibm db2 database?
What is explain plan in db2?
What type of database is db2?
What are the different types of base tables?
What is the purpose of rollback and commit?
What is dbrm? When it will be created?
What does sqlcabc has?
What do you mean by storage group (stogroup)?
What do you mean by rollback?
