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 / guest
NULL
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What do you mean by between and in? Is between inclusive of specified range values?
Explain the function of data manager.
What is the purpose of using commit?
What is ibm db2 client?
Which component is responsible for db2 startup and shutdown?
How can we retrieve the total number of records in RPG & CLLE?
What are the full forms of spufi and dclgen and why are they used?
Who uses db2?
What are types of indexes?
Which component is responsible for processing sql statements and selecting access paths?
What are packages in db2?
What is db2 catalog database?
How to check sequence on a table in db2?
What is role in db2?
What is performance tuning db2?