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
NULL
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is a db2 table?
How can you quickly find out the # of rows updated after an update statement?
what is the responsibility of the construction superintendent
What is nvl in db2?
What is cascading rollback?
What do you mean by storage group (stogroup)?
What is dclgen in db2?
What is temporal table in db2?
What is db2 connect?
Is the primary key a clustered index?
What is a Foreign Key?
What are the rules for db2 programming?
Comment whether the cursor is closed during commit or not.
What is database alias db2?
What is reorg?