Interested to Buy Any Domain ? << Click Here >> for more details...
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'
- 10 Answers
- 16295 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / vinay
answer is
(a.) 0
0 recod selected.
| Is This Answer Correct ? | 7 Yes | 19 No |
Post New Answer View All Answers
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What action db2 takes when a program aborts in the middle of a transaction?
What is the maximum number of columns in a db2 table?
Which command is used to remove all rows from a table?
What does db2 stand for?
Define check constraint.
How and when does the db2 enforces the unique key?
What is the use of dclgen in db2?
How do I add a column to a table in db2?
What is the maximum size of varchar data type in db2?
What is page size in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is access path in db2?
What db2 400?
What is cascading rollback?
