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 / swapnil
It depends up on the which database we are using. I m using
PostgreSQL it is in open source.It returns 0 value.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is a db2 table?
define clustering index.
Define sqlca.
What is the difference between oracle and db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is a db2 collection?
What are host variables in db2?
What is the clustering index in the db2 database?
How many types of page locks can be held in db2?
What is a dbrm in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is an instance in db2?
How to run db2 command in windows?
How do I connect my db2 database to ibm?
How do I import data from excel to db2?