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'
Answer Posted / vinay
answer is
(a.) 0
0 recod selected.
| Is This Answer Correct ? | 7 Yes | 19 No |
Post New Answer View All Answers
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Is db2 a mainframe database?
How to retrieve rows from a db2 table in embedded sql?
What are the benefits of using the db2 database?
On which levels locks can be applied?
What is the use of value function?
What is explain in db2?
Define sqlca.
Describe major components of db2?
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 consistency token in db2?
What are the various data types available in db2?
How do I create a view in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is page size in db2?