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 / 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
Which are the db2 tools to protect integrity of the database?
What is the purpose of using commit?
Who uses db2?
What are db2 tables?
Explain db2.
How do you stop a db2 database in linux?
What is reorg and runstats in db2?
Explain packages.
On which levels locks can be applied?
What is the difference between db2 and oracle?
What is database manager in db2?
Explain about rct in db2?
How is deadlock resolved?
What is the picture clause of null indicator variable?
What is null value in db2?