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
- 13535 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / rama krishna reddy
b
if no matching records found then it will return null value
| Is This Answer Correct ? | 36 Yes | 3 No |
Post New Answer View All Answers
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is scrollable cursor in db2?
How to check sequence on a table in db2?
What is runstats and reorg in db2?
How does a cursor work?
What is bind in db2?
How can you count the number of rows from a table tab?
What is a collection in db2?
Why do we use cursor?
What is the connection string to connect to the DB2 Database ?
What is db2 instance?
What is ibm db2 used for?
What is a db2 schema?
What is dpf in db2?
What is database manager in db2?
