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
- 16119 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
What is the role of schema in the db2 database?
What is host variable?
What is the maximum number of columns in a db2 table?
How to find the number of rows in a db2 table?
What is null in db2?
What is scrollable cursor in db2?
Which is faster delete or truncate?
What is the use of dclgen in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Explain about open switch business continuity software?
What is difference between alias and synonym in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Define db2.
What is explain in db2?
