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.
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
What is the difference between bind and rebind in db2?
What is db2 command?
What does runstats do in db2?
is it compulsory commitment control in journal?
What is cascading rollback?
How do you find the maximum value in a column in db2?
What is the use of runstats in db2?
Explain db2.
Highlight all the advantages that are attached to a package.
Where do you specify them?
What is explain plan in db2?
What is the use of with ur in db2?
Is db2 a programming language?
What is node in db2?
How to execute stored procedure in db2 command editor?