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
- 13536 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / varalakshmi
ANSWER IS B. IT GIVES NULL.
| Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
What is buffer pool?
Which isolation level provides highest data integrity?
Explain dclgen.
What is the difference between dbm cfg and db cfg file in db2 ?
What is the max length of sqlca?
can all users have the privilage to use the sql statement select * (dml)?
What is the difference between db2 and oracle?
What is runstats utility in db2?
What is collection in db2 bind?
How can you count the number of rows from a table tab?
When reorg is used?
Define check constraint.
If I have a view which is a join of two or more tables, can this view be updateable?
What is a collection in db2?
Explain about dbrm.
