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 is the difference between spufi and qmf?
What is a Foreign Key?
What is the difference between dbm cfg and db cfg file in db2 ?
What is db2 and what is the use of db2 optimizer?
Is db2 a database?
What is db2 connect?
What is buffer pool in the db2 database?
What is node in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Is db2 a mainframe database?
What is the syntax for FETCH in DB2 ?
How to restart a DB2 program?
Give a brief description of db2 isolation levels?
what is diffrence b/w file-aid tool and file-aid utility???
How does cobol compile db2 program?