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
- 16721 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / guest.
Lalit, I contradict your answe because the question itself
says that there is no matching record with
deptno='insurance'. So (b)is the correct answer.
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
is it compulsory commitment control in journal?
How to execute stored procedures?
Give the name of some fields form sqlca.
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
When the like statement is used?
How will you return the number of records in table?
what is utility for parm lib
Why cursor is used in db2?
What is a db2 schema?
What is iseries database?
Explain package in db2 and its advantages?
Can you use max on a char column?
What is the physical storage length of timestamp data type?
What is the function of logging in the db2 database?
What is with ur in db2?
