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
- 13601 Views
- Amdocs, I also Faced
- E-Mail Answers
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 the maximum size of varchar data type in db2?
What is access path in db2?
How can you quickly find out the # of rows updated after an update statement?
What type of database is db2?
Where do you specify them?
What is bind and rebind in db2?
Comment whether the cursor is closed during commit or not.
Can you use max on a char column?
What is db2?
What is ibm db2 used for?
what is the responsibility of the construction superintendent
How do I add a column to an existing table in db2?
How and when does the db2 enforces the unique key?
What is collection in db2 bind?
Name the various locking levels available?
