Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16287 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 access path in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is lock escalation in db2?
What is the use of with ur in db2?
What is cloudant database?
What is cobol db2?
What is dpf in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is node in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is a db2 collection?
B37 abend during spufi?
What is the reason behind not using select * in embedded sql programs?
What is dclgen (declaration generator)?
Is db2 a mainframe?
