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
- 16392 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
Discuss about db2 bind?
What is the use of value function?
What is db2 command?
What type of database is db2?
How does a cursor work?
How to restart a DB2 program?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is meant by union and union all?
What is database manager in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
define clustering index.
What is lock escalation in db2?
What is the information associated with sysibm.syslinks table?
What is bind plan?
What is db2?
