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
- 16705 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / pankaj
ans is a) ZERO
the anser is ZERO because there is no record in the table
they can shows the zero value present in the table
0 record is selected
message is disply
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is explain in db2?
Explain the function of data manager.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What's The Percentage Free Space ?
What is db2 catalog database?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Define sqlca.
What is temporal table in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is clone table?
What is the purpose of rollback and commit?
How do we specify index to include or not during bind process.
What is sqlca?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is with ur in db2?
