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 are packages in db2?
What is db2 catalog database?
What is runstats utility in db2?
Explain about rct in db2?
What is check constraint. Explain with example.
How do I add a column to an existing table in db2?
What is database alias db2?
How to retrieve rows from a db2 table in embedded sql?
Why cursor is used in db2?
How do I start db2 in windows?
What is db2 optimizer?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the default page size of buffer pools?
Explain db2.
What are union and union all?