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 temporal table in db2?
List down the types of triggers in the db2 database?
What type of database is db2?
What are the full forms of spufi and dclgen and why are they used?
What is package in db2 mainframe?
What does runstats do in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is bind and rebind in db2?
Which components manage deadlocks in db2?
What is scrollable cursor in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Can we insert update delete in view?
Define declaration generator (dclgen).
What's The Error Code For Unique Index Voilation?
Where can you declare a cursor in a cobol-db2 program?