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
- 16707 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / rama krishna reddy
b
if no matching records found then it will return null value
| Is This Answer Correct ? | 36 Yes | 3 No |
Post New Answer View All Answers
What is release/acquire in bind?
How can you classify the locks in db2?
How do you pull up a query which was previously saved in qmf?
What does sqlcabc has?
How can we read records for specific member in CL? AND rpg?
On which levels locks can be applied?
What is the syntax for FETCH in DB2 ?
Mention the definition of cobol in varchar field.
What is db2 and what is the use of db2 optimizer?
What kind of database is db2?
what is utility for parm lib
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What are concurrency issues?
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
Is db2 relational database?
