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
What parameters are used to control the free space in DB2?
What is the physical storage length of the data types date, time, and timestamp?
What are the prerogatives?
What is the difference between drop table and delete table?
What is a db2 tablespace?
How to find the number of rows in db2 tables?
What is bufferpool in db2?
What is access path in db2?
What is ibm db2 used for?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How to create db2 table in mainframe?
What is a bind card?
When the like statement is used?
What is dclgen (declaration generator)?