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
- 13525 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
Which components manage deadlocks in db2?
How do I delete a column in db2?
What is catalog database in db2?
What is cursor stability in db2?
What is a db2 package?
what is diffrence b/w file-aid tool and file-aid utility???
What are the contents of a dclmgen?
How do I add a column to a table in db2?
What are the various data types available in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is coalesce in db2?
How connect db2 database to datastage?
What are bind parameters in db2?
How can you quickly find out the # of rows updated after an update statement?
Explain about cursor stability?
